this is the sample of code in my DYL280 program
IF DYLSQLSTAT EQ 'E'
EXEC SQL CLOSE ITHST ENDEXEC
here I would like to know, when they check for DYLSQLSTAT EQ 'E' and what exactly it does. why do they check for this.
Though I haven't worked much in DYL280 having new DYLINSTL parameters for DB2, it looks like the statement is looking for a ROW. If it doesn't find one it Closes ITHST.
Does this suffice? Else please try running the DYL for cehcking results. Alternatively, as all DYL280 users would agree, give a wrong statement and DYL@80 will give you the reasons for its failure....great way to learn.