|
|
| Author |
Message |
satyender
New User
Joined: 05 Jan 2008
Posts: 40
Location: hyderabad
|
|
|
|
Hi,
Please excuse me if I am wrong,asking this question.
Can we unload a table using DSNTIAUL or by any other means into GDG? |
|
| Back to top |
|
 |
References
|
|
 |
rpuhlman
Active User
Joined: 11 Jun 2007
Posts: 75
Location: Columbus, Ohio
|
|
|
|
Hi Satyender,
Have you tried it?
Rick |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 989
Location: Virginia, USA
|
|
|
|
| I hope so, I've been doing it for 10 years, if it we can't I'm in big trouble. |
|
| Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008
Posts: 40
Location: hyderabad
|
|
|
|
HI rpuhlman,
I am trying, but ending up with errors. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 989
Location: Virginia, USA
|
|
|
|
| satyender wrote: |
HI rpuhlman,
I am trying, but ending up with errors. |
With more information we may be able to help you. |
|
| Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008
Posts: 40
Location: hyderabad
|
|
|
|
Yes, It is working perfectly.
Thanks all for your responses. |
|
| Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008
Posts: 40
Location: hyderabad
|
|
|
|
| Code: |
//STEP1 EXEC DSNUPROC,UID='GDGUNLD',UTPROC='',SYSTEM='DB2E'
//SYSREC00 DD DSN=T0J0AJ7.UNLOAD.TLCS135(+1),
// DISP=(,CATLG,DELETE),
// LABEL=EXPDT=99000,UNIT=VTAPE
//SYSPUNCH DD DSN=T0J0AJ7.GDG.SYSPUNCH.TLCS135,
// DISP=(,CATLG,DELETE),
// UNIT=DISK,SPACE=(CYL,(100,100),RLSE)
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
UNLOAD TABLESPACE tablespace name
FROM TABLE tablename ;
|
|
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 989
Location: Virginia, USA
|
|
|
|
| What error are you getting? |
|
| Back to top |
|
|
satyender
New User
Joined: 05 Jan 2008
Posts: 40
Location: hyderabad
|
|
|
|
| It was a operator error. |
|
| Back to top |
|
|
|
|
