Usage Note 63134: The enhanced ALLOWED_SQLCODES= option allows you to also ignore errors and warnings in the fetch step
 |  |  |  |  |
Starting in SAS® 9.4 (TS1M1), the ALLOWED_SQLCODES= LIBNAME option was added to allow users to specify DB2 SQL warnings and errors that SAS should ignore during the preparation and execution steps. Errors and warnings that occurred with a fetch step were not ignored.
Starting in SAS® 9.4 (TS1M6), the ALLOWED_SQLCODES= LIBNAME option has been enhanced to allow the fetch step errors and warnings to also be ignored.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.4 TS1M1 | 9.4 TS1M6 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7W.html#63134| Type: | Usage Note |
| Priority: |
| Date Modified: | 2018-11-01 11:44:53 |
| Date Created: | 2018-10-26 13:13:57 |