comma delimited file into fixed length file



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

comma delimited file into fixed length file

Postby meghs » Fri Apr 03, 2009 11:23 am

Hi,
is there any command/code to convert a comma delimited file into fixed length file?
My file contains amount as well..
meghs
 
Posts: 1
Joined: Thu Apr 02, 2009 7:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: comma delimited file into fixed length file

Postby swd » Fri Apr 03, 2009 6:14 pm

Hi meghs,

I'd write a COBOL program and use the UNSTRING verb, something like

UNSTRING record DELIMITED BY ","
INTO field1, field2, field3, field4, field5 etc....
END-UNSTRING

The fields would be part of a fixed file layout so when you write the record out it will be a FB file.

Hopefully this is what you're after.

Cheers
Steve
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post