Progress
Startup Command and Parameter
Reference


ANSI SQL (-Q)

Operating 
System
and
Syntax 
UNIX
Windows 
-Q 
Use
With 
Maximum
Value 
Minimum
Value 
Single-user
Default 
Multi-user
Default 
OID
 
 
 
 

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:

. . . WHERE _Field-name BEGINS ’ny’ 

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