View previous topic :: View next topic
|
Author |
Message |
venktv
New User
Joined: 29 Mar 2006 Posts: 59 Location: Montreal
|
|
|
|
Hi friends,
If any of you are having load JCL to load a Db2 table, please paste it here...
I want to load a db2 table from a seqeuntial file..
Thanks and Regards
Venkatesh |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
why not ask Your support
even if we posted the jcl, it would follow our standards
and You would have to modify it,
and maybe You would post again asking for explanation
and so on and so on
furthermore the db2 manuals have a good description of the utilities
and there is a library that should look like "DSN810.SDSNSAMP"
with lots of well documented samples |
|
Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Using DSNUPROC utility you can do.
You have to write LOAD card to load a file into table and pass it through SYSIN card. You only can write as you know the layout of the file. |
|
Back to top |
|
|
0d311
Guest
|
|
|
|
I think you can generate a load job via the DB2 admin tool (using the the DB2 system catalog)...
At least for us |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
venktv wrote: |
If any of you are having load JCL to load a Db2 table, please paste it here... |
Do you have BMCADM for DB2 available at your shop. |
|
Back to top |
|
|
Guru Bob
New User
Joined: 31 Jan 2008 Posts: 21 Location: Malaysia
|
|
|
|
i take it the bottom line of your signature is not working too well.
Reding the manuals on DB2 might help. |
|
Back to top |
|
|
sureshhbabu
New User
Joined: 16 Oct 2007 Posts: 2 Location: bangalore
|
|
|
|
Hi Friends,
Can you pls suggest us any more in this regard.If possible,Can some one pls come up with code snippet.
Regards,
Suresh |
|
Back to top |
|
|
kalhor
New User
Joined: 20 May 2007 Posts: 31 Location: iran
|
|
|
|
Hi
A sample job for load data into a DB2 table is ready, also some description is added. hop be useful
===============================================
//LOAD JOB (ACCOUNTING-INFO),'DB2 UTILITY'
//LOAD EXEC DSNUPROC,SYSTEM=DSN2, => THE DB2 SUBSYSTEM NAME
// UID='USERNAME'
//DSNUPROC.SYSREC DD DSN= DATA SET NAME WHICH YOU WANT TO BE LOADED
// DISP=SHR
//DSNUPROC.SYSIN DD DSN=THE CONTROL CARD OF YOUR TABLE YOU WANT TO LOAD INTO,
// DISP=SHR
//DSNUPROC.SYSUT1 DD DSN=TEST.SYSUT1,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(8192,(5,5),RLSE),
// UNIT=SYSDA
//DSNUPROC.SORTOUT DD DSN=TEST.SORTOU,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(8192,(5,5),RLSE),
// UNIT=SYSDA
//DSNUPROC.SORTWK01 DD DSN=OBKIHK1.TEST.SORTWK01,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(8192,(5,5),RLSE),
// UNIT=SYSDA
//DSNUPROC.SYSMAP DD DSN=TEST.SYSMAP,
// DISP=(MOD,DELETE,CATLG),
// SPACE=(8192,(5,5),RLSE),
// UNIT=SYSDA |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello Suresh and welcome to the forum,
Quote: |
Can you pls suggest us any more in this regard.If possible,Can some one pls come up with code snippet. |
At the top of the page is a link to "IBM Manuals". Among these are the documentation for releases of db2 (which contains the info you want and sample jcl).
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnugj10/2.1.5.3?
You will do yourself a huge favor if you become familiar with the IBM manuals (especially the search within the manuals).
If you find something in a manual that is not clear, post what you found and your doubt about this.
Someone will be able to clarify. |
|
Back to top |
|
|
sureshhbabu
New User
Joined: 16 Oct 2007 Posts: 2 Location: bangalore
|
|
|
|
Hi All,
Thanx for the stuff & suggestions you shared with me.
Regards,
Suresh |
|
Back to top |
|
|
|