Using multiple tablespaces in an UNLOAD statement

prathap.murthy · New User Joined: 10 Jan 2007 Posts: 5 Location: India

I'm planning to use INZUTILB to unload data from our databases for a requirement. In one such case, I need to join two tables that reside on separate tablespaces. Can we use multiple tablespaces in an UNLOAD statement?

Garpen · New User Joined: 03 Jan 2007 Posts: 14 Location: Sweden

Hi
You can use the old uNLOAD-pgm, DSNTIAUL and run the UNLOAD with a view.

//UNLOAD EXEC PGM=IKJEFT1B,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(ssid)
RUN PROGRAM(DSNTIAUL) -
LIB('ssid.RUNLIB.LOAD') PARMS('SQL')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC00 DD SPACE=(CYL,(10,10),RLSE),DISP=(,CATLG,DELETE),
// DSN=unloadfile
//SYSPUNCH DD SPACE=(CYL,(10,10),RLSE),DISP=(,CATLG,DELETE),
// DSN=syspunchfile
//SYSIN DD *
SELECT * FROM view;

rajandhla · Posted: Mon Jan 29, 2007 5:23 pm

I hope until you are connecting to same Db2 sub system no problem should exists..

Regards,
JR

Garpen · New User Joined: 03 Jan 2007 Posts: 14 Location: Sweden

I assumed that the tablespaces exists in the same subsystem

prathap.murthy · New User Joined: 10 Jan 2007 Posts: 5 Location: India

Yes... both the tablespaces exist within the same subsystem. Thanks for your time!