 |
|
| SAS/ACCESS Interface to Sybase |
Case Sensitivity in Sybase
SAS names can be entered in either uppercase or lowercase. When you reference Sybase objects through the SAS/ACCESS interface, objects are case sensitive and require no quotation marks.
However, Sybase is generally set for case sensitivity. Give special consideration to the names of such objects as tables and columns when the SAS ACCESS or DBLOAD procedures are to use them. The ACCESS procedure converts Sybase object names to uppercase unless they are enclosed in quotation marks. Any Sybase objects that were given lowercase names, or whose names contain national or special characters, must be enclosed in quotation marks. The only exceptions are the SUBSET statement in the ACCESS procedure and the SQL statement in the DBLOAD procedure. Arguments or values from these statements are passed to Sybase exactly as you type them, with the case preserved.
In the SQL pass-through facility, all Sybase object names are case sensitive. The names are passed to Sybase exactly as they are typed.
For more information about case sensitivity and Sybase names, see Naming Conventions for Sybase.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.