Chapter Contents

SAS/ACCESS Software for Relational Databases: Reference

Case Sensitivity in SYBASE

SAS names can be entered in either uppercase or lowercase. However, because SYBASE is generally set for case sensitivity, special consideration should be given to the names of objects (such as tables and columns) when they are to be used in the SAS System.

In batch mode, interactive line mode, and in the program editor, 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 Procedure Pass-Through Facility, all SYBASE object names are case sensitive. The names are passed to SYBASE exactly as they are typed.

Chapter Contents
Previous
Next
Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.