I am looking to FTP the a flat file, which contains COMP and COMP-3 feilds, to Oracle team out here...
So i need to Unpacked the COMP & COMP-3 fields so that they can receive the data in pure numeric and character format in the file.
Just one more thing i wanna ask... If we wanna show a exact value which is stored in the COMP-3 or COMP value. then what would be the data type of output fields used ?
One field of input file has - S9(15)V9(2) COMP-3 = -012345678912345.22
Second field of input file has- S9(10)V9(4) COMP = -0123456789.2233
Now i want to move the value in out put file so that when i open the output file it will show me the exact value of every comp-3/comp feilds i.e. For first field <-012345678912345.22> and <-0123456789.22
33>for second field.
Well, I understand but there's really no built-in functions to do that.
DFSORT has no knowledge of those declarations or any ability to translate them into output edit masks automatically. You could use the REXX program from the "Create DFSORT Symbols from COBOL Copybook" Smart DFSORT Trick at:
to create DFSORT Symbols, but the resulting symbols will only get you the DFSORT input formats (ZD, PD, etc). You are talking about "output formats" which DFSORT does with edit masks. I don't know of any tool to generate the correct edit masks from the COBOL copybook. You would have to specify the correct edit masks yourself based on the original COBOL declaration.