View previous topic :: View next topic
|
Author |
Message |
swati
New User
Joined: 14 Sep 2005 Posts: 7
|
|
|
|
how to send a data to DB2 thru JCL |
|
Back to top |
|
|
vicky10001 Warnings : 1 Active User
Joined: 13 Jul 2005 Posts: 136
|
|
|
|
Please explain questions once...
As my assumptions.
Updating data in tables thru jcl..Its correct |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
hi frnd,
v can give all types of query in SYSIN .. but i have not remembered the utility clearly.. i was confused with the name actually. if u know the name then plz let me know. |
|
Back to top |
|
|
vicky10001 Warnings : 1 Active User
Joined: 13 Jul 2005 Posts: 136
|
|
|
|
Can u do this JCL
//BATCHC EXEC PGM=IKJEFT1A
//STEPLIB DD DSN=SYS1.DB2?.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD DSN=???????.DB2APPL.UTIL.SYSC(DSNTEP2T),DISP=SHR
//SYSIN DD *
SELECT * FROM Tablename;
/* |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
hey you can use DXTREM , DSNTIAUL utility. |
|
Back to top |
|
|
yugi
New User
Joined: 24 Nov 2005 Posts: 1
|
|
|
|
I believe we can send the data by using PARM parameter also,
//systin dd *
Sub system name
plan, program , library and PARM=data
/*
please correct if I am wrong. |
|
Back to top |
|
|
tom_mat
New User
Joined: 13 Jul 2005 Posts: 11
|
|
Back to top |
|
|
|