Providing software solutions since 1976
Training & Bookstore
For SAS/ACCESS Interface to DB2 in the z/OS operating environment, an error similar to the following might occur upon invocation of a stored procedure.
DB2 execute error DSNT408I SQLCODE = -804, ERROR: AN ERROR WAS
FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL
STATEMENT, REASON 09
The error occurs when you call the stored procedure and you use a null parameter, as shown in the following SQL procedure:
This error occurs because of a change that IBM made to DB2 9 in which a character that is an empty string now results in an error. This error does not not occur with DB2 Version 8.
The workaround is to specify the null parameter with a macro and then reference the macro in the invocation, as shown in the following example:
Click the Hot Fix tab in this note to access the hot fix for this issue.
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: