Sybase DirectConnect Interface
\The Sandbox \PB History & Future \New In PB6 \Database Connectivity \Sybase DirectConnect
UI for DB Profiles
INFORMIX 7.x DB Interface
Oracle 7.3 DB Interface
Oracle 8.0 DB Interface
INTERSOLV DB2 ODBC Driver
Sybase Open Client 11.1
Sybase 10 & 11 Dist App Interface
Release DBParm
Sybase OC 11.1 Security
Sybase OC 11.1 Directory
Accessing MS SQL Server 6.5
ODBC 3.0
Sybase DirectConnect
CommitOn- Disconnect
DateTimeAllowed DBParm
DBGatewayUDT DBParm
FormatArgsAsExp DBParm
HostReqOwner DBParm
LowerCaseIdent DBParm
ModifySyntax DBParm
PWDialog DBParm
TableCriteria DBParm
ThreadSafe DBParm
TrimSpaces DBParm
TRS DBParm
AutoCommit in Net-Gateway
PBCatalogOwner in Oracle
Increased DBParm Strings
PRINT Stmts in Stored Procs
Nondefault DB Trace Log File
Automatically Connect to DB

Description

PowerBuilder and InfoMaker provide the Sybase DirectConnect database interface to access a variety of databases. Sybase DirectConnect is a data access server that provides a standardized middleware interface between your applications and your enterprise data sources. Data access services to a particular data source are defined in a DirectConnect server. Since a DirectConnect server can support multiple access services, you can access multiple data sources through a single server. When you use the DirectConnect interface to connect to a particular database, your connection is routed through the access service for that database.

Supported platforms

The DirectConnect interface is initially available on the Windows NT and Windows 95 operating system platforms.

Supported databases

The DirectConnect interface initially provides support for connections to a DB2/MVS database. The DirectConnect interface connects to a Sybase DirectConnect for MVS access service on a DirectConnect server. This access service then works with the IBM mainframe to access DB2 data.

DBMS identifier  When you specify the DBMS identifier in a PowerBuilder application script, use DIR to connect to a database via the DirectConnect interface.

  • To specify the DIR DBMS identifier in a PowerBuilder script:

    • Type the following in your PowerBuilder application script:

    SQLCA.DBMS="DIR"

    When you select DIR DirectConnect in the Database Profiles dialog box and click New to create a new profile, this syntax displays on the Preview tab in the Database Profile Setup - DirectConnect dialog box. You can copy the syntax from the Preview tab into your script.

DBParm parameters

The DirectConnect interface supports a number of existing DBParm parameters as well as a several new parameters:

  • DBGatewayUDT
  • HostReqOwner
  • LowerCaseIdent
  • TableCriteria
  • TrimSpaces
  • TRS
PBL Peeper PB Help PB History & Future About Us Feedback Site Map

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