Description

All the PowerBuilder database interfaces (except Oracle) have been enhanced to provide support for ANSI SQL-92 outer join SQL syntax generation. PowerBuilder 8 supports both left and right outer joins in graphics mode and full outer and inner joins in syntax mode. For three database interfaces, DIR, SYC and MSS, the database connection defaults to ANSI outer join SQL syntax if the database server supports ANSI. For the remaining four database interfaces, you must select the version of outer join SQL syntax you want PowerBuilder to generate using a new DBParm called OJSyntax.

When ANSI outer join SQL syntax generation is important Selecting the version of SQL syntax PowerBuilder should generate when you create an outer join is relevant only when you create a new DataWindow. The SQL syntax used in existing DataWindows is not changed.

Usage

Generating outer join syntax when using DIR The DIR database interface code always defaults to using ANSI outer join SQL syntax.

Generating outer join syntax when using SYC The SYC database interface code checks to determine the version of the ASE database server to which you are connecting. If you are connecting to ASE 12 or higher, SYC automatically defaults to using ANSI outer join SQL syntax.

Generating outer join syntax when using MSS Like SYC, the MSS database interface code checks to determine the version of the SQL Server database server to which you are connecting. If you are connecting to Version 7 or higher, MSS automatically defaults to using ANSI outer join SQL syntax.

Generating outer join syntax when using IN7/9, JDBC, ODBC, and OLE DB If you are using one of these four database interfaces, you must set the OJSyntax DBParm to indicate the version of outer join SQL syntax you want PowerBuilder to generate. Possible values are:

The OJSyntax DBParm is set using a dropdown listbox on the Syntax tab.