New in PowerBuilder 6 - INFORMIX 7.x Database Interface

\The Sandbox \PB History & Future \New In PB6 \Database Connectivity \INFORMIX 7.x DB Interface

Description

PowerBuilder and InfoMaker provide a new INFORMIX IN7 native database interface that accesses the following INFORMIX database servers:

INFORMIX-OnLine Versions 5.x, 6.x, and 7.x
INFORMIX-SE Versions 5.x and 6.x

The INFORMIX IN7 database interface goes through INFORMIX ESQL Version 7.2 client software to make the connection. Therefore, you must have INFORMIX ESQL Version 7.2 installed on your client machine to use the interface.

Supported platforms

PowerBuilder and InfoMaker provide the INFORMIX IN7 interface on the following platforms:

Windows NT
Windows 95

The INFORMIX IN7 interface uses a Powersoft DLL named PBIN760.DLL to access the database. PBIN760.DLL is a 32-bit Windows DLL. 16-bit Windows support is available through Win32s.

Purpose

Use the INFORMIX IN7 database interface when you want to access an INFORMIX 7.x database server in PowerBuilder or InfoMaker through the INFORMIX ESQL Version 7.2 client software.

If you are using INFORMIX-NET Version 5.x client software, you should instead use the INFORMIX IN5 database interface in PowerBuilder or InfoMaker to access an INFORMIX 7.x database server.

Usage

The information in Connecting to Your Database about using the INFORMIX IN5 database interface also applies when you use the INFORMIX IN7 database interface, with the following differences:

Required client software To use the INFORMIX IN7 database interface in PowerBuilder or InfoMaker, make sure the following software is installed on the client machine as appropriate for your operating system platform:

INFORMIX ESQL Version 7.2 (or ESQLC for the C language)
PowerBuilder or InfoMaker Version 5.0.03 or higher
INFORMIX IN7 native database interface that comes with PowerBuilder or InfoMaker

DBMS identifier When you specify the DBMS identifier in a PowerBuilder application script, you must use IN7 to connect to the database through the INFORMIX IN7 database interface. (You no longer need to specify the DBMS identifier in a database profile. When you create a new profile for any installed Powersoft database interface, PowerBuilder or InfoMaker generates the correct DBMS connection syntax automatically.)

To specify the IN7 DBMS identifier in a PowerBuilder script:

Type the following in your PowerBuilder application script:

SQLCA.DBMS="IN7"

When you select IN7 INET V7.x 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 - INFORMIX IN7 dialog box. You can then copy the syntax from the Preview tab into your script.

Server name When you specify the server name value in a database profile (to connect in the PowerBuilder or InfoMaker development environment) or in a script (to connect in a PowerBuilder application), you must use the following format to connect to the database through the INFORMIX IN7 interface:

host_name@server_name

Parameter	Description
host_name	The name of the host computer running the INFORMIX database server. This corresponds to the INFORMIX HOSTNAME environment variable
server_name	The name of the server containing the INFORMIX database. This corresponds to the INFORMIX SERVER environment variable

For example, to use the INFORMIX IN7 interface to connect to an INFORMIX database server named server01 running on a host machine named sales, do either of the following:

To specify the server name in a database profile:

Type the host name (sales) in the Host Name box and the server name (server01) in the Server box on the Connection tab in the Database Profile Setup - INFORMIX IN7 dialog box. PowerBuilder or InfoMaker saves this server name as sales@server01 in the database profile entry in your initialization file.

To specify the server name in a PowerBuilder script:

Type the following in your PowerBuilder application script:

SQLCA.ServerName = "sales@server01"

If you specify a value for Host Name and Server in your database profile, this syntax displays on the Preview tab in the Database Profile Setup - INFORMIX IN7 dialog box. You can then copy the syntax from the Preview tab into your script.

Except for those differences noted here, you prepare to use, define, and set additional connection parameters for the INFORMIX IN7 database interface in PowerBuilder and InfoMaker the same way as for the INFORMIX IN5 database interface.