- Vsam File Structure
- Types Of Vsam Files
- Reading Vsam Files In Cobol
- Vsam Files In Informatica Developer Download
Install PowerExchange server on Informatica server machine. Create a datamap for COBOL in PowerExchange Navigator tool. Launch Developer Tool/Client. Open the Connection Explorer. Configure connections. S elect Non-Relational. Select either Sequential or VSAM depending on how the datamap was configured in step-3 above. Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies. Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. VSAM stands for Virtual Storage Access Method. VSAM is a file storage access method used in MVS, ZOS and OS/390 operating systems. It was introduced by IBM in 1970's. It is a high performance access method used to organize data in form of files in Mainframes. VSAM is used by COBOL and CICS in Mainframes to store and retrieve data.
Vsam File Structure
Active1 year ago
I'm working in PowerCenter Designer on a Cobol Mainframe VSAM sourcefile and need to know what values in
A coworker mentioned Informatica recognizes it like
Prec
and Scale
should I use to get a PIC S9(9)V99 COMP-3
...A coworker mentioned Informatica recognizes it like
PIC S9(9)V9(2) COMP-3
, and so I had to defined the field with Prec 11
- Scale 2
, and I did that, but once data gets loaded in Stage table in SQL, then some fields show strange symbols for some columns, and other columns show expected values. I also tried adding an Expression transformation for dividing by 100 the resulting value gotten from the Normalizer, but it didn't work as expected either.
Do you have any idea about how could it be handled?
Giulio Caccin1,61722 gold badges2222 silver badges3535 bronze badges
Ciro1977Ciro1977
2 Answers
The '
pic s9(9)V99 COMP-3
' is interpreted as follows:s -- signed.9(9) nine number digits.V the implied decimal point.99 -- two numeric digits comp-3 -- packed decimal.
In informatica this would be '
prec 11 scale 2
'.Cannot remember how you tell Power Center its packed decimalbut I know you can. Packed Decimal: two decimal digits in each byte with a special sign character in the last nibble.So +123456 is stored as hexadecimal
James Anderson'0123456C'.
( +123.456 would be stored as exactly the same hex string -- you just have to know what the scale you are expecting!)Types Of Vsam Files
James Anderson24.9k66 gold badges4141 silver badges7171 bronze badges
Remember that a comp-3 field means that the value is compressed, so if you open with a text editor will show you those strange characters not the specific numberyou can saw those values with the extension PowerExchange
Reading Vsam Files In Cobol
Fabian91Fabian91