Chapter Contents |
Previous |
Next |
SAS/ACCESS Interface to CA-DATACOM/DB: Reference |
The DDBTRACE option is available as a data set option on your PROC statement or DATA step. You can also set DDBTRACE as a systems option. For example, if DDBTRACE equals 1, you can look at the WHERE clause that was processed. If you specify DDBTRACE=1, the view descriptor WHERE clause and the SAS WHERE clause, if any, appear on the SAS log. The display also shows the various fields that make up the key fields. For example, suppose POLI is a key field composed of two fields, PO and LI, and you specify
poli eq \2222\0000
The WHERE clause display echos back
po eq 2222 and li eq 0000
Note: The engine translates the SAS WHERE clause (if any) as much as possible
into CA-DATACOM/DB format and connects it to the view WHERE clause with the
AND operator.
The text of most error messages is self-explanatory. However, some error messages have a prefix containing a display code decimal number. This prefixed number contains the CA-DATACOM/DB return code and the internal return code. For example, in the following message
10.0 Duplicate Master Key not allowedthe number 10 is the return code and 0 is the internal return code.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.