Description

PowerBuilder and InfoMaker provide a new DBParm parameter named ModifySyntax for use with the Sybase Systems 10 and 11 CT-Lib interface on all supported platforms.

When you are using this interface to access the database, ModifySyntax controls whether PowerBuilder or InfoMaker modifies the WHERE clause to optimize performance when it queries Sybase SQL Server for result set descriptions. By default, ModifySyntax is set to 1 to perform the WHERE clause modification.

For some complex SQL queries containing nested SUBSELECT statements, modifying the WHERE clause generates illegal SQL syntax. If you are issuing a complex query, you can turn off the default WHERE clause modification by setting ModifySyntax to 0.

Purpose

If ModifySyntax is set to 1 and you issue a complex SQL query containing a nested SUBSELECT statement, an error message may display indicating that the SQL syntax is incorrect. To help you avoid such syntax errors, set ModifySyntax to 0 to turn off PowerBuilder's or InfoMaker's default modification of the WHERE clause.

Usage

As with any other DBParm parameter, you can set ModifySyntax in the Database Profile Setup dialog box for your connection or in a PowerBuilder application script.