Problem Note 8603: "No data found" error occurs when trying to update or delete from a DB2
table with SQL
An error occurs if you try to update or delete from a DB2 table within
SQL Pass Through if the WHERE condition is never met.
If the column in the table does not contain any rows that have the value
to meet the WHERE condition, an error similar to the following will
occur:
ERROR: CLI prepare error: No data found/modified
This also occurs with Oracle.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#008603
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2003-01-15 12:11:19 |
| Date Created: | 2002-10-07 11:34:32 |
