Skip to main content

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