Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Filling DB2 tables using Sequential Files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
iknow

Senior Member


Joined: 22 Aug 2005
Posts: 582
Location: Colarado, US
PostPosted: Thu Oct 13, 2005 8:09 am    Post subject: Filling DB2 tables using Sequential Files
 Reply with quote
Hi All
How to read record from a file and insert the same into tables? I use COBOL and DB2.
Back to top
View user's profile Send private message
References
priyesh.agrawal

Global Moderator


Joined: 28 Mar 2005
Posts: 1509
Location: Chicago, IL
PostPosted: Mon Oct 17, 2005 4:12 pm    Post subject: Re: Filling DB2 tables using Sequential Files
 Reply with quote
Quote:
How to read record from a file

By READ Statement.

Quote:
insert the same into tables?

INSERT command in SQL query by moving the read value to host variable.

Regards,

Priyesh.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1