ANSI Outer Join SQL Syntax
\The Sandbox \PB History & Future \New In PB8 \ANSI Outer Join
Workspaces
Code Examples
UI changes
Working with 
PB8
Starting PB
System Tree
Library painter
Clip & Output
Source editor
AutoScript
Source Control
Exception
Handling
Web Targets
4GL Web
Pages
Web DW
Scripting
Web DW
Container
Web DW
Events
Server-side
Methods
JavaScript
Includes
HTML
Rendering
EAServer
Profiles
EAS/Existing
Interfaces
EJB Clients
EAS
Transactions
SSL
Connections
Concurrency
Property
Multiple
PB VMs
DB Interfaces
ANSI
Outer Join
Proxy
Connections
Loading
DB Libs
PB.INI/DB Info
Command Line
Deployment
Version
for EXEs
Color Support
New Object
Properties
DW
Expressions
DW
Properties
PowerScript
Functions
SaveObject
OLE Event
DBCS Support
GUIDs & MIMEs

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:

Value

Description

PB

Generate the outer join SQL syntax defined for this interface in previous PowerBuilder releases

ANSI

Generate ANSI standard SQL syntax (default for Informix)

ANSI_ESCAPE

GenerateANSI SQL syntax that uses the outer join escape notation (default for JDBC, ODBC, and OLE DB)

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

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com