View previous topic :: View next topic
|
Author |
Message |
anita_lao
New User
Joined: 06 Oct 2005 Posts: 7
|
|
|
|
Need to copy a DB2 table to a flat file. Told not to use BMC. Note: it is TABLE not tablespace that needs to be backed up. |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Can you DSNTIAUL
Code: |
//STP0100 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSREC00 DD DSN=DOWLOAD.DATASET,
// DISP=(,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(CYL,(100,100),RLSE)
//SYSPUNCH DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2S)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL')
END
/*
//SYSIN DD *
SELECT * FROM TABLE.NAME
;
/*
|
You can also use PLATINUM
Code: |
//STP0400 EXEC PGM=PTLDRIVM,
// PARM='EP=UTLGLCTL/DB2S',
// REGION=32M,
// COND=(0,LT)
//PTILIB DD DSN=........
//PTIPARM DD DSN=........
//PTIXMSG DD DSN=........
//SYSIN DD *
FASTUNLOAD
UNLDDN SYSREC
LOAD-CONTROL DB2LOAD
OUTPUT-FORMAT DSNTIAUL
INPUT-FORMAT TABLE
SHRLEVEL CHANGE
SELECT *
FROM TABLE.NAME
/*
//SYSUT1 DD SYSOUT=*
//SYSDISC DD SYSOUT=*
//SYSERR DD SYSOUT=*
//SYSMAP DD SYSOUT=*
//SYSREC01 DD DSN=DOWNLOAD.DATASET,
// DISP=(,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(CYL,(50,20),RLSE),
// VOL=,
// DCB=(MODEL.DSCB1)
//PTIMSG DD SYSOUT=*
//PTIIMSG DD SYSOUT=*
//ST01MSG DD SYSOUT=*
//SYSCTL01 DD SYSOUT=*
//SYSOUT DD SYSOUT=*
|
|
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
Back to top |
|
|
anita_lao
New User
Joined: 06 Oct 2005 Posts: 7
|
|
|
|
Got the following error message when I used
SELECT * FROM db2 table
DSNT502I ERROR IN DSNTIAUL SQL INPUT:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "*". SOME SYMBOLS THAT MIGHT BE
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 7 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'0000
INFORMATION |
|
Back to top |
|
|
anita_lao
New User
Joined: 06 Oct 2005 Posts: 7
|
|
|
|
Thank you. DSNUPROC worked. |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Quote: |
Got the following error message when I used
SELECT * FROM db2 table
DSNT502I ERROR IN DSNTIAUL SQL INPUT:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "*". SOME SYMBOLS THAT MIGHT BE
|
You might have missed semi-colon , this should also work if you want to try adding ';' at the end. |
|
Back to top |
|
|
anita_lao
New User
Joined: 06 Oct 2005 Posts: 7
|
|
|
|
Tried the ';' but got the error message
DSNE117E NOT ABLE TO LOCATE DSNTIAUL IN DSNAME SYS1.LINKLIB |
|
Back to top |
|
|
Gautam512
Active User
Joined: 05 Oct 2005 Posts: 308 Location: Vizag / US
|
|
|
|
i think u need to use the correct link libraries or there is a chance like, that particular dsn utility is there in ur shop.... |
|
Back to top |
|
|
|