INET_SERVICE

Description

Specifies the name of the service that a remote Informix database server uses to listen to all incoming requests from client applications.

Applies to

INF Informix

IN9 Informix

Syntax

INET_SERVICE='service_name'

Parameter

Description

service_name

A string that specifies the name of the service that a remote Informix database server uses to listen to incoming requests

For information about the correct service name for your site, see your Informix system administrator.


Default value

By default, PowerBuilder uses the service name specified in the HKEY_LOCAL_MACHINE\SOFTWARE\Informix\SqlHosts registry key.

Examples

Example 1

To specify that your Informix database server uses the sqlexec service name:

  • Database profile

    Type sqlexec in the Service Name box on the Network page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="INET_SERVICE='sqlexec'"

Example 2

You can specify values for INET_DBPATH, INET_PROTOCOL, and INET_SERVICE together. To specify that the directory /Informix contains Informix databases, and that you want to connect using the turbo service and the olsoctcp network protocol:

  • Database profile

    Type /Informix in the Database Path box, turbo in the Service Name box, and olsoctcp in the Protocol Type box on the Network page in the Database Profile Setup dialog box.

  • Application

    Type the following on a single line in code:

    SQLCA.DBParm="INET_DBPATH='/Informix',INET_SERVICE='turbo',INET_PROTOCOL='olsoctcp'"

See also

INET_DBPATH

INET_PROTOCOL