Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Uploading a CSV file into a DB2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ranjanp

New User


Joined: 02 May 2006
Posts: 25

PostPosted: Fri Sep 22, 2006 1:08 am    Post subject: Uploading a CSV file into a DB2 table
Reply with quote

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.
Back to top
View user's profile Send private message

vijayarockiarajkp

New User


Joined: 18 Jul 2006
Posts: 7
Location: USA

PostPosted: Sun Sep 24, 2006 1:48 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
prashanth1

New User


Joined: 27 Sep 2006
Posts: 47
Location: Hyderabad

PostPosted: Tue Oct 03, 2006 2:03 pm    Post subject:
Reply with quote

Hi VJ


Can you pls elaborate the same.
Back to top
View user's profile Send private message
ranjanp

New User


Joined: 02 May 2006
Posts: 25

PostPosted: Tue Oct 03, 2006 11:50 pm    Post subject:
Reply with quote

Its pretty much elaborated. can you please let me know your specific questions. That might help me to give you a better clarification.
Back to top
View user's profile Send private message
MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Wed Oct 04, 2006 1:48 am    Post subject: Re: Uploading a CSV file into a DB2 table
Reply with quote

What is CSV format.

To load data in Db2 table you can use DSNUTLIB or PLATINUM utility.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us