Progress
Startup Command and Parameter
Reference
ANSI SQL (-Q)
Use ANSI SQL (
-Q
) as necessary to enforce strict ANSI SQL conformance when processing Progress/SQL statements. Progress/SQL meets or extends the ANSI SQL standard. However, there are a few cases where Progress extensions conflict with the ANSI SQL standard. Use-Q
if you want strict adherence to the standard.By default, Progress/SQL character value comparisons are not case sensitive. This conflicts with the ANSI standard. Progress character fields (columns) and variables are defined as case insensitive by default. If you use
-Q
, then for any CREATE TABLE statements executed during that session, all columns default to case sensitive. (Columns defined as case insensitive prior to running a Progress session are not affected by-Q
.)For more information on case sensitivity, see the DEFINE PARAMETER, DEFINE VARIABLE, and DEFINE WORKFILE reference entries in the Progress Language Reference.
Note that case sensitivity for columns and variables applies only to the stored data values; the actual table names, column names, and variable names are never case sensitive, nor are comparisons involving these names. For example, the following comparison is never case sensitive:
The
-Q
parameter also enforces code that ensures that there are no temporary unique constraint violations.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |