File-aid reformat to decompress comp-3 data

Deepika Pai · New User Joined: 13 May 2010 Posts: 7 Location: India

Hello,

I have a extract which I have download it and load into a open systems database. So I need to decompress the comp-3 fields to readable data and add delimiter. If we use the file-aid reformat option how can I convert the comp-3 fields to readable preferably file-aid batch.

Thanks for your help!

dick scherrer · Posted: Wed Jan 05, 2011 10:58 am

Hello,

Suggest you change the extract to generate a delimited file with all of the numeric fields edited to formats readily usable on the target system.

Tab (x'05') works well for a delimiter and numeric fields work best when they are "complete". For example a negative value of dollars and cents ( pic s9(3)v99 ) would be edited to contain the value 123.45- for use on the target system.

Deepika Pai · New User Joined: 13 May 2010 Posts: 7 Location: India

Hi Dick,

Thanks for the quick response!!

I was able to achieve the adding delimiter part with file-aid reformat option. I was trying to see if the decompressing the comp-3 to readable can be achieved through the same file-aid reformat option.

dick scherrer · Posted: Wed Jan 05, 2011 8:57 pm

Hello,

How is the data being "extracted"?

To me, it would be better to create the download file as part of the extract rather than some extra pass/copy of the data to re-format/edit. . .

Deepika Pai · New User Joined: 13 May 2010 Posts: 7 Location: India

Hello,

My input fields has a as is extract from the database so all numeric fields are comp-3 field. Even if I define them as Comp-3 display in file-aid output formatting it only expands the field leaving the sign character as is.

Is there way I can numeric edit them in file aid reformatting efficiently ?
In the example you have quoted above if we want file-aid to generate 123.45- in file-aid reformatting if the input extract has a field definition of pic s9(3)v99 comp-3.

Thanks!

dick scherrer · Posted: Thu Jan 06, 2011 7:57 pm

Hello,

Is there some reason you are determined to use File-Aid? None of the "extracts" any of the teams i've worked with use a File-Aif reformat/copy of the data. They read the database and generate the delimited file with the numeric values edited for ease-of-use on the target system.

There must be something i am completely missing. . .