DYL280 program query

CIBER · New User Joined: 31 May 2006 Posts: 1 Location: bangalore

Hi
this is the sample of code in my DYL280 program
IF DYLSQLSTAT EQ 'E'
EXEC SQL CLOSE ITHST ENDEXEC
QUIT
ENDIF
here I would like to know, when they check for DYLSQLSTAT EQ 'E' and what exactly it does. why do they check for this.

renu

yogesh.jamdar · New User Joined: 21 Apr 2006 Posts: 4 Location: USA

Renu,
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.

cheers...

Yogi