Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us