![Vsam Files In Informatica Software Vsam Files In Informatica Software](/uploads/1/2/5/6/125641942/824642445.png)
I'm working in PowerCenter Designer on a Cobol Mainframe VSAM sourcefile and need to know what values in 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?
Software Developer. Convert and Process Virtual Storage Access Method Data. You must tell IRI you have VSAM files in order to get its special driver for file. Mar 25, 2018 - Procedure division Your COBOL source file may already be in the COBOL file format, or it may be a COBOL copybook. A COBOL copybook.
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 decimal but 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 '0123456C'. ( +123.456 would be stored as exactly the same hex string - you just have to know what the scale you are expecting!).