compte rendu JCL update incomplet [Résolu]

[niko34]

Bonjour à tous,

j'ai créé un JCL comprenant un step d'update db2 / SQL ; tout se déroule bien, mais le compt-rendu de job ne précise pas le nombre d'occurrences màj.

merci de m'indiquer ce qui manque ...

LE JCL
//MAJLOT2 EXEC PGM=IKJEFT01,COND=(4,LT)
- - - - - - - - - - - - - - - - 14 Line(s
//SYSTSPRT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSTSIN DD *
DSN SYSTEM(DB2S)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB81) PARMS('SQL,250')
//SYSIN DD *
SET CURRENT SQLID='DV03U';
UPDATE
HEA27V
SET
CCFVIB = '1'
,LIMVBS = LIMVB
,DMVIB = CURRENT_DATE
,HMVIB = CURRENT TIME
WHERE
IDVIB IN
( SELECT A.IDVIB
FROM DV03U.HEA27V A
,DV03U.HEA27W B
WHERE
B.IDCLBM = '0000019833' AND
A.IDVIB = B.IDVIB
AND A.NULDVB = '000'
AND A.CCFVIB ='0'
AND A.CDBIC2 <> ''
AND A.CDIBAN <> '' )
;
COMMIT;




Le compte-rendu

DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT416I SQLERRD = 0 0 2 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000002' X'FFFFFFFF'
INFORMATION

COMMIT
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
******************************** BOTTOM OF DATA *************************


Merci à tous.

Niko34

[Luc Orient]

Pour moi, le programme que vous utilisez ( DSNTIAUL) est surtout utile pour exécuter une requête de sélection et mettre le résultat dans un fichier.

DSNTIAUL
The sample unload program. This program, which is written in assembler language, is a simple alternative to the UNLOAD utility. It unloads some or all rows from up to 100 DB2 tables. With DSNTIAUL, you can unload data of any DB2 built-in data type or distinct type. You can unload up to 32 KB of data from a LOB column. DSNTIAUL unloads the rows in a form that is compatible with the LOAD utility and generates utility control statements for LOAD. DSNTIAUL also lets you execute any SQL non-SELECT statement that can be executed dynamically

A mon sens, c'est plutôt DSNTEP2 qu'il vous faut.

DSNTEP2
A sample dynamic SQL program that is written in the PL/I language. With this program, you can execute any SQL statement that can be executed dynamically. You can use the source version of DSNTEP2 and modify it to meet your needs, or, if you do not have a PL/I compiler at your installation, you can use the object code version of DSNTEP2.

[niko34]

merci; cela fonctionne parfaitement avec 'DSNTEP2'.

Nicolas