PROC DB2EXT requires that you place a blank space following the plus sign (+) on the SELECT clause if a numeric constant follows the operator. If a variable name follows the plus sign, the space is not required. The following expressions work correctly:

select salary+bonus

or:

select salary + 1000

however, the following:

select salary+1000

produces these errors:

ERROR: Expecting ;. ERROR: The symbol is not recognized and will be ignored. ERROR: Expecting a ). ERROR: Statement is not valid or it is used out of proper order

The only current workaround is to add a space between the plus sign and the numeric constant.