IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to convert Flat File to CSV in batch


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
barthwalsamarth

New User


Joined: 03 Aug 2006
Posts: 9

PostPosted: Tue Nov 23, 2010 11:20 am
Reply with quote

Hi

I have a requirement where I need to convert a flat file to CSV file and then I may have to FTP/NDM the file.

Can you please suggest any utility or process to do the conversion in batch.


Thank You
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Nov 23, 2010 12:43 pm
Reply with quote

Can barthwalsamarth please search the forum as this has been asked and answered.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Nov 23, 2010 9:39 pm
Reply with quote

Hello,

When i need to create a downloadable/delimited file i use STRING in a bit of cobol code. Typically, i use the tab character (x'05') for the delimiter as this does not occur in text data and is easily used after the download.

Make sure the file to be downloaded contains no packed-decimal or binary data.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top