Kbase 20985: How to suppress the ORDER BY clause in the SQL queries generated by Oracle dataserver?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/25/2005 |
|
Status: Unverified
GOAL:
How to suppress the ORDER BY clause in the SQL queries generated by Oracle dataserver?
GOAL:
What is -zod startup parameter?
FACT(s) (Environment):
Oracle DataServer
Progress 9.1B
FIX:
Starting with Version 9.1A, the DataServer ORACLE defines an ORDER BY clause on the SQL statement sent to ORACLE, when a join is performed by ORACLE based on the schema definitions, even when there is no order specified in the 4GL query.
The following patches for Progress 9.1B introduce a way to control the use of ORDER BY on queries with joins:
Compaq Tru64 UNIX 9.1B11
HP-UX 64-bit 9.1B09
HP-UX 11 9.1B11
IBM AIX 9.1B14
Linux Intel 9.1B06
SUN Solaris 9.1B12
SUN Solaris Intel 9.1B11
UNIX V.4 9.1B07
Windows NT 32 Intel 9.1B19
Use the session startup parameter -zod to suppress the ORDER BY when there is no order defined in the 4GL join.
The -zod session parameter will suppress the entire ORDER BY clause from a join that would not otherwise be ordered at compile time. This prevents the DataServer client from adding ORDER BY to the query sent to ORACLE when there is no BY clause in the joint query.