Starting in SAS® 9.4 TS1M1, the TK environment variable DB2SUPPRESS204 enables you to suppress the list of DSN00204E messages to be disabled


Before SAS® 9.2 TS2M3, in the z/OS operating environment, a check for the existence of a DB2 table results in an error saying that the table does not exist, even if the table should not exist. An error similar to the following is written to the log:

ERROR: File DB2LIB.OLD.DATA does not exist.

Starting in SAS 9.2 TS2M3, an error similar to the following is also written to the log even if the table does not exist:

DB2 ERROR: RESULT OF SQL STATEMENT: DSN00204E SASTEST.NEWTAB IS AN UNDEFINED NAME A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0 SQLCODE: -204 SQLSTATE: 42704 SQLERRP: DSNXOTL

Starting in SAS® 9.4 TS1M1, the DSN00204E errors are suppressed. The original error is still written if the DB2 table should exist but does not exist. To revert to having the DSN00204E message written to the log even when it is not really an error, set the TK environment variable DB2SUPPRESS204 to N. This can be done by adding 'set DB2SUPPRESS204=N' in the TKMVSENV file.