Db2 table update in batch mode

Anu R · New User Joined: 09 Apr 2008 Posts: 18 Location: India

I have to update a DB2 table using an update query through batch.Is there any JCL available for this?

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

search for SPUFI in batch or DSNTIAD...

Anu R · New User Joined: 09 Apr 2008 Posts: 18 Location: India

hi acevedo,

Thanks for the reply but is ther an option to run SPUFI in batch mode...we have only online.

acevedo · Active User Joined: 11 May 2005 Posts: 344 Location: Spain

DSNTEP2 aka Spufi in batch.

Anu R · New User Joined: 09 Apr 2008 Posts: 18 Location: India

I used the following JCL

//STP0100 EXEC PGM=IKJEFT01
//SYSREC00 DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
RUN PROGRAM(DSNSTEP2) PLAN(DSNSTEP2) LIB('DB2TEST.RUNLIB.LOAD')
END
/*
//SYSIN DD *
my SQL query
/*

and I get the following error..does anyone have a solution for this?

READY
DSN SYSTEM(DB2T)
COMMAND DSN NOT FOUND
READY
RUN PROGRAM(DSNSTEP2) PLAN(DSNSTEP2) LIB('DB2TEST.RUNLIB.LOAD')
INVALID KEYWORD, PLAN(DSNSTEP2)
READY
END
READY
END

ruodeer · New User Joined: 06 Jul 2007 Posts: 58 Location: home

enrico-sorichetti · Posted: Tue May 20, 2008 3:05 pm

Ask Your support for the proper jcl and libraries to use...
looks like a db2 library is not in the search concatenation
( something like