DB2 UNLOAD with 2 operators in the WHEN syntax as example below:
UNLOAD DATA FROM TABLE ABC HEADER NONE
(ABC_CHAR,
ABC_NUMBER,
ABC_CHAR2
)
WHEN (ABC_NUMBER >= 5
AND ABC_NUMBER < 8
causing JCL to fail with error :
DSNU050I DSNUGUTC - UNLOAD DATA FROM TABLE ABC HEADER NONE DSNU650I DSNUUGMS - (ABC_CHAR, DSNU650I DSNUUGMS - ABC_NUMBER, DSNU650I DSNUUGMS - ABC_CHAR2 DSNU650I DSNUUGMS - ) DSNU650I DSNUUGMS - WHEN (ABC_NUMBER >= DSNU082I DSNUGPRS - INVALID KEYWORD - =, syntax error DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
Full article: https://portal.microfocus.com/s/article/KM000017330
#EnterpriseDeveloper
#SupportTips/KnowledgeDocs