Hello all,
The following is not updating &RECORDS:

ENGINE SQLDBC SET PASSRECS ON
SQL SQLDBC INSERT INTO TRVDEV3.XXX SELECT DL_DOCNO FROM TRVDEV3.DOCLISTV
;
END
-TYPE RECORDS &RECORDS LINES &LINES RETCODE &RETCODE
-RUN

Get the following return:
(FOC1364) ROWS AFFECTED BY PASSTHRU COMMAND : 1650/INSERT
RECORDS 0 LINES 0 RETCODE 0

I tried SQL SQLDBC as well as ENGINE. Just want to have an amper var set to the number of rows inserted/updated/ or deleted .. Thanks. j

This message has been edited. Last edited by: Kerry,

  
ENGINE SQLDBC SET PASSRECS ON
SQL SQLDBC INSERT INTO TRVDEV3.XXX SELECT DL_DOCNO FROM TRVDEV3.DOCLISTV
; 
END
-RUN
-******************************************************
-* This displays all the & variables available to you
-? &
-******************************************************

-TYPE Total Inserts: &INCLUDE

&INCLUDE is not on the list of amper variables. Weird. I will open a ticket. Thanks.