Description

The INFORMIX database interface has been enhanced to provide support for ANSI outer join SQL syntax generation and five additional database parameters.

Usage

Support for ANSI SQL-92 outer join syntax generation The INFORMIX interface can now generate ANSI SQL-92 outer join SQL syntax when you create a new DataWindow. For more information, see Support for ANSI outer join SQL syntax generation.

Async This DBParm allows you to perform asynchronous operations on your database in PowerBuilder. By default, PowerBuilder operates synchronously.

DBGetTime When you set the Async parameter to 1 to enable asynchronous operation, you can also set the DBGetTime parameter. DBGetTime specifies the number of seconds you want PowerBuilder to wait for a response from the DBMS when you retrieve rows in a DataWindow object, query, or report.

DelimitIdentifier This DBParm specifies whether you want PowerBuilder to enclose the names of tables, columns, indexes, and constraints in double quotes when it generates SQL statements. The default value is No.

ThreadSafe This DBParm specifies whether your connection should take advantage of the database server threadsafe client libraries. The default value is No.

DecimalSeparator This DBParm specifies the decimal separator setting used by the backend DBMS that you are accessing.

For more information

See the DBParm description in the online Help for:

Async
DBGetTime
DecimalSeparator
DelimitIdentifier
OJSyntax
ThreadSafe

For information about new DBParms, select the What's New button on the Help window and select New DBParms.