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

how do we insert into DB2 table using a FB file as input


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
teevijay

New User


Joined: 20 Mar 2006
Posts: 22

PostPosted: Tue May 06, 2008 10:58 am
Reply with quote

How do we insert into DB2 table using a FB file as input in a JCL step.

Many thanks in advance for your help.

Regards.
Vijay
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 May 06, 2008 11:19 am
Reply with quote

Hello,

You "load" the data from a qsam file into the db2 table.

Following is a bit of a sample - talk with your dbs(s) or someone else on your project for the proper jcl for your system.

Code:
//LOADTABL EXEC PGM=DSNUTILB
. . .
//TABLDS  DD DSN=your.data.set,DISP=SHR
//SYSIN DD *
LOAD DATA INDDN TABLDS
INTO TABLE EMPLOYEE
/*

You might also try the "Search" at the top of the page as ther are multiple topics about loading data from a file into a db2 table.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
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
Search our Forums:

Back to Top