|
View previous topic :: View next topic
|
| Author |
Message |
bkvinay7
New User
Joined: 31 May 2007
Posts: 4
Location: banglore
|
|
|
|
I am looking for a job that reads Rows from table(DB2) and write it to a QSAM dataset.
INPUT is QUERY and table
OUTPUT selected ROWS |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
From Your signature..
| Quote: |
| cool guy always looking easiest way to do things..... |
/wisdom on
the easiest way of doing things is to do them Yourself,
and when asking for help, to show that You have tried to help
Yourself before asking
/wisdom off |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Vinay,
U can use DSNTIAUL utility
| Code: |
//UNLOAD EXEC PGM=IKJEFT1A,DYNAMNBR=20
//STEPLIB DD DSN=SYS1.DSNDSNE.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSNE)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
LIB('SYS1.DSNDSNE.RUNLIB.LOAD') PARMS('SQL')
//*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD DSN=Output data set
//SYSPUNCH DD DUMMY
//SYSIN DD *
Put ur sql here
/* |
|
|
| Back to top |
|
|
srikanthkailasam
New User
Joined: 13 Nov 2006
Posts: 24
Location: Bengalooru
|
|
|
|
| similar to this can we write it into a VSAM dataset????? |
|
| Back to top |
|
|
|
|
