Setnet Help Index
Contents

Overview

Setnet Procedures

Saving Environment Information

Saving Server Information

Saving Host Information

Getting Version Information


Entering A User Name

UserName  The UserName for your account on the host machine.


Entering a Valid Password

Password  The Password you use to access your account on the host machine.


Entering the HostName

HostName  The Name of the host machine with which you establish a connection.

Use the drop-down list box to select from available host names or enter a new name.


Entering the ServiceName

ServiceName  The ServiceName that the remote database server uses to listen to all incoming requests.


Entering the Options

Options  Enter options specific to the database server. Refer to Server Administrator's Guide for more information.


Entering the ProtocolName

ProtocolName  The name of the Protocol identifies which Network Protocol should be used. You can select a protocol from the drop-down list box.

The drop-down list box contains a list of all available protocols. Setup program creates a list of all available protocols.


Cancel Operation

Cancel Ignores changes made in the Setnet information since the last Apply operation and exits from Setnet.


About Setnet

About Setnet  tab Furnishes information about the Setnet Utility including the version number and serial number.


Overview

Setnet is a utility that allows you to interactively change environment variables and configure servers with different parameters. Information can then be saved in a registry or in a file. ESQL/C refers to the information that is saved in the registry.

Setnet is organized as a set of tabs.

Tab	Use
Environment	To set environment variables
Server Information	To set run-time values of server related variables
Host Information	To set run-time values of host related variables
About Setnet	To get version information and serial number
For further information see

Saving Environment Information

Saving Server Information

Saving Host Information

Getting Version Information


Environment Information
Saving Environment Information

In Setnet use the first tab Environment to set environment variables.

Following environment variables can be set using the first tab. To see their meaning and possible values, See Understanding Environment Variables

	BIG_FET_BUF_SIZE
	CC8BITLEVEL
	CLIENT_LOCALE
	COLLCHAR
	CONRETRY
	CONTIME
	DB_LOCALE
	DBALSBC
	DBANSIWARN
	DBAPICODE
	DBASCIIBC
	DBCENTURY
	DBCODESET
	DBCONNECT
	DBCSCONV
	DBCSOVERRIDE
	DBCSWIDTH
	DBFLTMSK
	DBDATE
	DBLANG
	DBMONEY
	DBMONEYSCALE
	DBNLS
	DBPATH
	DBSS2
	DBSS3
	DBTEMP
	DELIMIDENT
	ESQLMF
	FET_BUF_SIZE
	GL_DATE
	GL_DATETIME
	IFX_PAD_VARCHAR
	INFORMIXDIR
	INFORMIXSERVER
	INFORMIXSQLHOSTS
	LANG
	LC_COLLATE
	LC_CTYPE
	LC_MONETRAY
	LC_NUMERIC
	LC_TIME

Press the Server Information tab to set Server Parameters. See Saving Server Information for more details.

Press the Host Information tab to set Host Parameters. See Saving Host Information  for more details

Press the About Setnet tab to get information about serial number and Setnet version.

Press From File to load Setnet with information from a file. See Loading Setnet From A File for more details.

Press To File to save Setnet information to a file. See Saving Setnet Information To File for more details

Press Ok to save Setnet information to the registry and quit. See Saving Information To Registry for more details

Press Cancel to exit without saving the changes.

Press Apply to save Setnet information to the registry. See Saving Information To Registry for more details

Press Help to invoke Setnet help (This application)


Setnet Help
Help

Press Help  button to invoke Setnet help (This application)


Server Information
Saving Server Information

Use Server Information tab to set server related variables.

Server Information tab can be used to set parameters needed to connect to a database server. Following parameters can be set

Informix Server  see Entering Informix Server Name

HostName  see Entering the Host Name

ServiceName  see Entering Service Name

Protocol see  Entering the Protocol Name

Options  see Entering Options

In addition following buttons can be used

Push Buttons

Delete Server

OK

Cancel

Apply

Help

Press Ok to save the information and exit from Setnet.

Press Cancel to leave Setnet without saving the information.

Press Apply to save the information.

Press Help to get help on Setnet (This application).

For more information on the registry see Saving Information To Registry


Host  Information
Saving Host Information

Host Information tab can be used to set parameters associated with a given host. Following parameters can be set

HostName  see Entering the Host Name

UserName  see Entering A User Name

Password  see Entering a Valid Password

PasswordOption  see Selecting Password Option

Push Buttons

Delete Host

OK

Cancel

Apply

Help

For more information on the registry see Saving Information To Registry


Delete Server

Delete Server Press this button to delete the information associated with the server from the registry


Delete Host

Delete Host  Press this button to delete the information associated with the host from the registry


Save Setnet Information
Apply / OK  - Save Setnet Information

Apply  Saves the information associated with All the environment variables. It also saves all the information associated with different servers and different hosts. Information associated with servers consists of HostName, ServiceName, and ProtocolName. Information associated with the hosts consist of UserName, PasswordOption and Password. The information is stored in the registry.

OK  Saves the information in the same way as above and exits from Setnet.

To get more information about the registry organization  see Saving Information To Registry


Enter Server Name

You can select a name from the combo box or enter a new name in the combo box. Any information associated with a new name will be saved to the registry only when the Apply or Ok button is pressed.

To get more information about the registry organization  see Saving Information To Registry


Load From File
Loading Setnet From A File

Press this button to load Setnet from a previously saved file. This file should have been previously created by Setnet. You can browse the directories to select the proper file once you are prompted for a file name

Files created by Setnet do not contain information about all the available protocols. Thus, Save/Load operation will not help in moving information about available protocols from one machine to another. Only setup program will create registry entries related to available protocols.

See also Entering the ProtocolName


Save To File
Saving Setnet To A File

Press this button to save Setnet information to a file. Another dialog box would prompt you for a file name where information should be saved. You can also browse the file system to select a particular file as the destination.

Information is saved in the ini file format.

See also Entering the ProtocolName


Save Registry
Saving Information To Registry

Setnet information is stored in the registry when the user presses Apply or OK.

By default, the information is stored in HKEY_LOCAL_MACHINE. If the “Use my  settings” check box is checked, the entries are stored in HKEY_CURRENT_USER.

Environment variables are stored under the ENVIRONMENT subkey of the Informix key. They are stored as different values of the ENVIRONMENT key.

Host information is stored under the NETRC subkey of Informix Key. For each configured host a subkey is created under Netrc This contains information associated with each host name. This consists of host name, user name, password and requirement of password information at connect-time. In addition to the host subkeys, Netrc contains one value - PROTOCOLLIST. This corresponds to the list of protocols.

Information related to different servers is kept under SQLHOSTS subkey of the Informix key in the HKEY_LOCAL_MACHINE hive. The full path is  \HKEY_LOCAL_MACHINE\software\Informix

For each configured server a subkey is created under  SQLHOSTS. This contains information associated with each server name. This consists of host name, service name, and protocol.

Central Registry

If the environment variable INFORMIXSQLHOSTS points to a remote machine name, the information is stored in the HKEY_LOCAL_MACHINE  hive of the remote machine. If INFORMIXSQLHOSTS variable does not have any value the information is stored on the machine where Setnet is run. This mechanism allows different users from different machines to share a common configuration of servers.  CAVEAT:  A user A  on machine M may use a server from a central registry from machine C, only if all the server information is valid in his context on Machine M.

Example

A user Jane is on Machine Hydra. She wants to use information in a central registry on machine Icarus. She would then set the environment variable INFORMIXSQLHOSTS=\\Icarus in Setnet.

Central registry has 3 servers BigServer, TinyServer and YetAnotherServer.

Now suppose that Jane wants to run a client program on Hydra and use Sever BigServer from the central registry. Following values are associated with BigServer:

	host= BigMachine	/*  host machine for server BigServer */
	service=service1	/*  Service that BigServer uses to listen to the client requests */
	Protocol=olsoctcp	/* protocol used to communicate with BigServer */

If the service “service1” has not been defined on Hydra, Jane will not be able run a client program on Hydra to connect to BigServer.


Ask Password At Run-Time

Selecting this option specifies that your application is to prompt for password at the time of connection to a server.

Selecting this option disables the Password Edit Control in Server Information Tab..


No Password

Selecting this option specifies that the user account has no password.

Selecting this option disables the Password Edit Control in Server Information Tab..


Password

Selecting this option specifies that the user account has a password. Selecting this option enables the Password Edit Control. Password can then be entered in the Password Edit Control.


Host Information
Use this tab to edit information related to a particular host.


Current Host
Use this to set information about a host. You may select an existing host from the drop-down list or define a new host.


User Name
Use this field to set the user name on “Current Host”


Password Option
Select the password option for connecting to the host


Password
Use this field to set the password


Delete Host
Use this button to delete the current host.


Server Information
Use this tab to set server related information


Informix Server
Use this drop-down combo-box to select an existing server or enter a new server.


SQL Host Name
Use this drop-down combo-box to select an existing host or enter a new host.


Protocol Name
Use this drop-down list-box to select a protocol.


Service Name
Enter service name the that the remote database server will use to listen to all incoming requests


Options
Enter options specific to the database server. Refer to Server Administrator's Guide for more information.


Make Default Server
Use this button to make the current server default InformixServer.


Delete Server
Use this button to delete the current server.


Informix Client Server Environment

The list shows environment variables and their current values. If a variable does not show any value associated with it, ESQL/C will use a default value. To see defaults associated with different variables see help topic  - Default values


Edit Variable
Select a variable from the Informix Client Server Environment listbox for editing. The name will appear as a label for the edit box. Current value is shown in the edit box. Use Set button to assign the value displayed in the edit box. Use Clear button to remove the value currently associated with the variable.


Variable Name
This displays the name of the selected environment variable. If no variable has been selected it shows the caption - Variable Name


Variable Value
Shows the value of the selected variable. You can edit this value or select from any values in the drop_down combo box.


Set Variable
Use this button to assign the displayed value to the selected variable.


Clear Variable
Use this button to clear any value assigned to the displayed variable.


Save / Load Setnet
You can save Setnet information to a file or load it with information from a previously saved file.


Load Setnet From File
Use this button to load Setnet from a previously created file.


Save Setnet To File
Use this button to save Setnet information for later use.


Default values

To see the meaning of these environment variables see, Understanding Environment Variables

If there are no values associated with any environment variable, ESQL uses following default values.

Environment Variable	Default Value (If any)
CC8BITLEVEL	2
CLENT_LOCALE	None
COLLCHAR	N
CONRETRY	1
CONTIME	15
DB_LOCALE
DBALSBC
DBANSIWARN	N
DBAPICODE
DBASCIIBC
DBCENTURY
CC8BITLEVEL

.


Password Options

Ask Password at Run-Time

Selecting this option specifies that your application is to prompt for password at the time of connection to a server. Selecting this option  disables the Password Edit Control in the Host Information Tab.

No Password

Selecting this option specifies that the user account has no password. Selecting this option disables the Password Edit Control in Server Information Tab..

Password

Selecting this option specifies that the user account has a password. Selecting this option enables the Password Edit Control. Password can then be entered in the Password Edit Control.


About Setnet Tab
Furnishes information about the Setnet Utility including the version number and serial number.


Development Team
Created by - Galileo Development Team

Sam Hamilton

Del Blevins

Nihar Mehta

Umesh D. Joglekar

Neeraj Gupta


Current Host

Use this drop-down combo-box to set information about a host. You may select an existing host from the drop-down list or define a new host.


File Load Dialog
Read Setnet Info File Dialog

File Name  Type the name of a file which contains Setnet32 information. If you type a pattern using a wildcard (* or ?) and press ENTER, the list box displays files matching that pattern.

Directories  Double-click a directory entry to display files from that directory in the Files box.

Drives  Click the arrow to display a list of all attached drives. Click a drive from that list to display directories and filenames from the selected drive.

List Files Of Type  Click the arrow to display a list of file types. The filename extension determines the file type. Click a file type to display a list of all files of that type from the current drive and directory in the File Name box.

Read Only  Select the check box to open the selected file as a read-only file.

Network  Press this button to browse the network and connect to shared directories.

Tips  You can double-click a filename in the list box to open the file. You can select a file type from the List Files Of Type box to display a list of all files with a predetermined type from the current drive and directory.

If you type a pattern using a wildcard (* or ?) in the File Name box and press ENTER, the list box displays files matching that pattern.


Save Setnet Info As Dialog

Use this dialog box to save the contents of setnet32 in a file.

File Name Type the name of a file where setnet32 contents should be saved. If you type a pattern using a wildcard (* or ?) and press ENTER, the list box displays files matching that pattern.

Directories  Double-click a directory entry to display files from that directory in the File Name box.

Drives  Click the arrow to display a list of all attached drives. Click a drive from that list to display directories and filenames from the selected drive.

Save Files As Type  Click the arrow to display a list of file types. The filename extension determines the file type. Click a file type to display a list of all files of that type from the current drive and directory in the File Name box.

Network Press this button to browse the network and connect to shared directories.

Tips You can select a file type from the Save Files As Type box to display a list of all files with a predetermined type from the current drive and directory.

If you type a pattern using a wildcard (* or ?) in the File Name box and press ENTER, the list box displays files matching that pattern.


Understanding Environment Variables

Environment Variable	Purpose	Possible Values (default Value)
BIG_FET_BUF_SIZE	Allows you to override the default size of the fetch buffer	Valid buffer size less than 4MB, in bytes. This environment supported only for XPS server from 8.40.UC1 onwards (Default value depends on row size).
CC8BITLEVEL	Specifies how the C-language compiler processes non-ASCII (8- bit and multibyte) characters. ESQL/C only	Refer to Chapter 2 of the Guide to GLS Functionality. (2)
CLIENT_LOCALE	Specifies the locales that the ESQL/C application uses to perform read/write operations that involve the keyboard, display, file, or printer on the client computer.	Any valid locale specifier. Refer to Chapter 2 of the Guide to GLS Functionality. (None)
COLLCHAR	Specifies that existing ESQL/C applications take advantage of the NLS collation feature without requiring a change in their code. You must also set DBNLS to 1 or 2. Provided for backward compatibility with NLS products.	(n)
CONRETRY	Specifies the maximum number of additional connection attempts made to a datives server in the time limit that CONTIME specifies. Same as INFORMIXCONRETRY.	(1)
CONTIME	Specifies the number of seconds an SQL CONNECT statement continues to try establishing a connection before it generates an error. Same as INFORMIXCONTIME.	(15)
DB_LOCALE	Specifies the locale of all the databases that an ESQL/C application accesses in a single connection (the database locale).	Any valid locale name
DBALSBC	When set to 1, enables compatibility with ALS products.	0 or 1
DBANSIWARN	When turned on (y), causes the ESQL/C preprocessor to check for Informix extensions to ANSI-standard SQL syntax at compile time, and causes an ESQL/C application to check for Informix extensions at runtime.	(n)
DBAPICODE	allows pre-7.2 systems that use nonstandard or rare code sets to access databases that store data in a standard code set. Maximum size = 23 characters. Provided for backward compatibility with NLS and ALS products.	Usage and values depend on language system. Refer to NLS and ALS documentation for descriptions.
DBASCIIBC	When set to 1, enables compatibility with ASCII Cop. Products.	0 or 1
DBCENTURY	Specifies how to expand values of two-digit-year DATE and DATETIME values. P = past century, R = present century, C = closest century.	“P” “R” “C”  Refer to the Informix Guide to SQl: Reference. (“R”)
DBCODESET	Specifies an Asian-locale code set. Overrides the code set that DB_LOCALE specifies. Provided for backward compatibility with Version 4.x and 5.x ALS products.	Same value as ALS DBAPICODE. (“8859-1::” unless the informix.rc file specifies another system-wide default).
DBCONNECT	Specifies whether or not connections are restricted.	1 or 3
DBCSCONV	Controls code-set conversion initialization . Maximum size is 8 characters. Provided for backward compatibility with ALS products.	“1” or “2:<codesetname>” Refer to 5.0 ALS documentation.
DBCSOVERRIDE	Forces the user-specified DB_LOCALE to override default restrictions on accessing databases with locales different from DB_LOCALE. Provided for backward compatibility with Version 6.0 ALS database servers.	0 or 1
DBCSWIDTH	Maximum number of display bytes (1-2) and storage bytes (1-4) for the characters in up to three code sets. Display and storage widths are separated by commas; code sets are separated colons. Maximum size of this field is, therefore, 11 characters. Provided for backward compatibility with ALS products.	Example: 1,1:2,3 means a display and storage width of 1 byte for character set 1;a display width of 2 bytes and a storage width of 3 bytes for code set 2.
DBDATE	Specifies the end-user format for DATE values so that they can conform with various international date conventions. Provided for backward compatibility with pre-7.2 products. Informix recommends GL_DATE for new applications.	(“MDY4” unless NLS variable LC_TIME is activated)
DBFLTMSK	Specifies the number of decimal digits to use when storing a DECIMAL, SMALLFLOAT, or FLOAT data type in a character buffer.	0-16 (16)
DBLANG	Specifies the subdirectory of the %INFORMIXDIR% directory that contains the product -specific message (.iem) files.	(%INFORMIZDIR%\msg)
DBMONEY	Specifies the end-user format for MONE values so that they can conform with various international and local monetary conventions.	(“$.,”)
DBMONEYSCALE	Specifies the total number of digits and number of decimal digits for monetary values.  Provided for backward compatibility with NLS products.
DBNLS	Specifies whether an ESQL/C application can access NLS features. Provided for backward compatibility with NLS products.	(n)
DBPATH	Identifies the database severs (online) or directories (SE0 that contain databases that the ESQL/C application accesses.
DBSS2	Maximum size is 4 characters. Provided for backward compatibility with ALS products.	“0x00”-“0xff” or “0”-“255”
DBSS3	Maximum size 4 characters. Provided for backward compatibility with ALS products.	“0x00”-“0xff” or “0”-“255”
DBTEMP	Specifies the directory on the client computer that the ESQL/C processor uses to store temporary files (also called swap files).	(\tmp)
DBTIME	Specifies the end-user format for DATETIME values so that can conform with various international date conventions. Provided for backward compatibility with pre-7.2 products. Informix recommends GL_DATETIME for new ESQL/C applications.	(“%Y-%m-%d%H:%M:%S”)
DELIMIDENT	Indicates whether (y) or not (n) to interpret strings in double quotes as delimited identifiers.	(n)
ESQLMF	Indicates whether the ESQL/C processor automatically invokes the ESQL/C multibyte filter (value=1 and CC8BITLEVEL<3, or not value=0). ESQL/C only.
FET_BUF_SIZE	Allows you to override the default size of the fetch buffer.	Any valid buffer size, in bytes. (Default value depends on row size).
IFX_PAD_VARCHAR	When set to 1, for varchar datatype client sends padded trailing spaces	1 or no value (By default client sends without trailing spaces)
GL_DATE	Specifies a customized end-user format for DATE values.	Refer to Chapter 2 of the Guide to GLS Functionality.
GL_DATETIME	Specifies a customized end-user format for DATETIME values.	Refer to Chapter 2 of the Guide to GLS Functionality.
INFORMIXDIR	Identifies the location of the ESQL/C processor as well as the location of library files, message files, header files, and other executables.	(\usr\informix)
INFORMIXSERVER	Identifies the default databse server.
INFORMIXSQLHOSTS	Specifies the name of the computer on which the central registry resides.
LANG	Specifies the language environment (called a locale) for an NLS database that the ESQL/C application accesses. Provided for backward compatibility with NLS products.	(C)
LC_COLLATE	Specifies a collation or sort sequence for data in NCHAR and NVARCHAR columns of an NLS database. Provided for backward compatibility.	Refer to Chapter 4 of the Informix Guide to SQL:Reference in your pre-7.2 documentation. (value that LANG specifies)
LC_CTYPE	Specifies character attributes such as character classification and case conversion of regular expressions for data in NCHAR and NVARCHAR columns of an NLS databse. Provided for backward compatibility.	Refer to Chapter 4 of the Informix Guide to SQL: Reference in your pre-7.2 documentation. (value that LANG specifies)
LC_MONETARY	Specifies the end-user format for MONEY values in an NLS database. Provided for backward compatibility.	Refer to Chapter 4 of the Informix Guide to SQL: Reference in your pre-7.2 documentation. (value that LANG specifies)
LC_NUMERIC	Specifies the end-user format for numeric values in an NLS database. Provided for backward compatibility with NLS products.	Refer to Chapter 4 of the Informix Guide to SQL:Reference in your pre-7.2 documentation. (value that LANG specifies)
LC_TIME	Specifies the end-user format for DATE and DATETIME values in an NLS database. Provided for backward compatibility with NLS products.	Refer to Chapter 4 of the Informix Guide to SQL:Reference in your pre-7.2 documentation. (value that LANG specifies)
For more information about these environment variables, their syntax, and acceptable values, see Chapter 4 of the Informix Guide to SQL:Reference.