Description

Since PowerBuilder 7, the DirectConnect interface has been enhanced to provide support for gateway-less database connections to DB2/MVS databases via Open ServerConnect. Consequently, the TRS DBParm has been modified and a new DBParm, UseProcSyntax, added.

In addition, the DirectConnect interface has been enhanced to provide support for ANSI outer join SQL syntax generation and two additional database parameters — DecimalSeparator and FormatArgsAsExp.

Usage

DIR support for Open ServerConnect Sybase's Open ServerConnect middleware data access product supports mainframe applications that retrieve and update data stored on the mainframe that Sybase client applications can execute. Client applications can connect directly to a DB2/MVS database via an Open ServerConnect application residing on the mainframe, eliminating the need for an intermediate gateway like DirectConnect. In addition, an Open ServerConnect application presents mainframe Remote Procedure Calls (RPCs) as database stored procedures to the client application.

TRS Previously, you used the TRS DBParm to specify whether your application should use the Transaction Router Service (TRS) on the DirectConnect server to connect to the DB2/MVS database. Now you use the TRS DBParm to indicate whether you want your application to connect to a DB2/MVS database using:

DirectConnect Access Service for DB2/MVS

DirectConnect TRS

Open ServerConnect

You can set the TRS DBParm in either the DIR Database Profile Setup dialog box or in a PowerBuilder application script. The possible values are:

The Connect Via TRS checkbox previously used to set TRS in the Database profile has been replaced. You now set TRS by selecting one of the three options in the Choose Gateway dropdown listbox on the Connection tab.

UseProcSyntax The UseProcSyntax DBParm applies only if you are using Open ServerConnect to make a gateway-less database connection. It specifies whether PowerBuilder should convert the syntax for invoking a Remote Stored Procedure (RSP) or host-resident request before executing that procedure.

Support for ANSI SQL-92 outer join syntax generation The DIR 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.

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

FormatArgsAsExp This DBParm controls whether PowerBuilder converts a DataWindow retrieval argument of decimal data type to scientific (exponential) notation if the argument exceeds 12 digits but is less than 16 digits.

ShowWarnings This DBParm was added to PowerBuilder 7 after its original release. It specifies whether warning message text can be concatenated to existing error messages.

For more information

See the DBParm description in the online Help for:

DecimalSeparator
FormatArgsAsExp
TRS
UseProcSyntax
ShowWarnings

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