Hello,
I wanted to create DB2 objects in a batch, and I got SQL error -144 which leaves me very perplexed. I have the following message:
DSNTIAD - SAMPLE DYNAMIC SQL PROGRAM 2.0
CREATE STOGROUP PGSG001
VOLUMES (FAN003)
VCAT PG8997
Error during SQL EXECUTE IMMEDIATE
SQLCODE = -144 DSNT408I, ERROR: INVALID SECTION NUMBER 1
SQLSTATE = 58003 SQLSTATE DSNT418I RETURN CODE
DSNT415I SQLERRP = DSNXERT SQL PROCEDURE ERROR DETECT
DSNT416I SQLERRD = -215 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD X'FFFFFF29 = 'X'00000000' X'00000000 'X'FFFFFFFF' X'000 00000 'SQL DIAGNOSTIC
INFORMATION
with the following JCL:
006500 / / EXEC PGM = PH01S01 IKJEFT01, DYNAMNBR = 20, COND = (4, LT)
006600 / / DD SYSOUT =* SYSTSPRT
006700 / / DD * SYSTSIN
006800 DSN SYSTEM (DB8G)
006900 RUN PROGRAM (DSNTIAD) PLAN (DSNTIA81) -
007000 LIB ('DSN810.RUNLIB.LOAD')
007100 / / SYSPRINT DD SYSOUT =*
007200 / / DD SYSOUT =* SYSUDUMP
007300 / / SYSIN DD *
007400
007410 CREATE STOGROUP PGSG001
007,420 VOLUME (FAN003)
007430 VCAT PG8997;
Thank you for your help.