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
 
DB2 Table- Load JCL

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

New User


Joined: 29 Mar 2006
Posts: 59
Location: Montreal

PostPosted: Wed Jun 04, 2008 12:13 pm    Post subject: DB2 Table- Load JCL
Reply with quote

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Wed Jun 04, 2008 12:25 pm    Post subject: Reply to: DB2 Table- Load JCL
Reply with quote

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
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Wed Jun 04, 2008 12:34 pm    Post subject:
Reply with quote

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
View user's profile Send private message
0d311

Guest





PostPosted: Wed Jun 04, 2008 5:47 pm    Post subject:
Reply with quote

I think you can generate a load job via the DB2 admin tool (using the the DB2 system catalog)...

At least for us icon_biggrin.gif
Back to top
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jun 04, 2008 8:27 pm    Post subject: Re: DB2 Table- Load JCL
Reply with quote

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
View user's profile Send private message
Guru Bob

New User


Joined: 31 Jan 2008
Posts: 21
Location: Malaysia

PostPosted: Thu Jun 05, 2008 1:34 pm    Post subject:
Reply with quote

i take it the bottom line of your signature is not working too well.

Reding the manuals on DB2 might help.
Back to top
View user's profile Send private message
sureshhbabu

New User


Joined: 16 Oct 2007
Posts: 2
Location: bangalore

PostPosted: Sun Aug 02, 2009 12:32 pm    Post subject: Reply to: DB2 Table- Load JCL
Reply with quote

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
View user's profile Send private message
kalhor

New User


Joined: 20 May 2007
Posts: 31
Location: iran

PostPosted: Sun Aug 02, 2009 8:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Aug 02, 2009 9:54 pm    Post subject:
Reply with quote

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).
http://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
View user's profile Send private message
sureshhbabu

New User


Joined: 16 Oct 2007
Posts: 2
Location: bangalore

PostPosted: Mon Aug 03, 2009 11:45 pm    Post subject:
Reply with quote

Hi All,

Thanx for the stuff & suggestions you shared with me.


Regards,
Suresh
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 Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

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