Uploading a CSV file into a DB2 table

ranjanp · New User Joined: 02 May 2006 Posts: 25

First of all let me make it clear that I am not sure that in which forum I should ask this question because my requirement has to parts:

First FTPing a CSV file from personal PC to Mainframes using a JCL
Next is to use the CSV file from Mainframe and upload the values to a DB2 table.

Hope that the admins wont give me a warning for this. Now coming to the issue.

I have a requirement wherein I need to FTP a file in CSV format from my PC Drive to Mainframes. Let me know how can I do it.

Next is to use the the above Mainframe file to load a DB2 table. Please let me know what are the ways of accomplishing the 2nd step.

Any help in this regard is greatly appreciated.

vijayarockiarajkp · New User Joined: 18 Jul 2006 Posts: 7 Location: USA

Hi,

For the point No 1 am not sure about the JCl but for the point number 2 you can try the folowing steps in cobol

1. Unstring the Input rec delimited by comma
2. Format the input rec if needed
3. finally insert the record into the tables

prashanth1 · New User Joined: 27 Sep 2006 Posts: 47 Location: Hyderabad

Hi VJ

Can you pls elaborate the same.

ranjanp · New User Joined: 02 May 2006 Posts: 25

Its pretty much elaborated. can you please let me know your specific questions. That might help me to give you a better clarification.

MFRASHEED · Active User Joined: 14 Jun 2005 Posts: 186 Location: USA

What is CSV format.

To load data in Db2 table you can use DSNUTLIB or PLATINUM utility.