Settings in the SQL-DB.INI File
The initialization file SQL-DB.INI contains information that defines the environment for the ADABAS applications on your PC as well as individual settings for your work with the different ADABAS tools.
This appendix contains an overview of some settings in the SQL-DB.INI file and explains how you may change these settings in the file.
To change settings which cannot be determined within the ADABAS tools, you must use a text editor, such as "editor" (notepad), to edit the SQL-DB.INI file directly. Do not use a formatting editor because you could damage your SQL-DB.INI file with it.
Settings not described in the appendix should not be modified.
The syntax of the settings corresponds to the conventions of Windows initialization files (see Windows documentation).
[Protocols] Section
Default: %DBROOT%\prot\tcpip.prt
Purpose: Determines the target file for the TCP/IP protocol file. The target directory must not be write-protected (important for the installation on a NetWare Fileserver).
Modify: Use the editor to edit the file.
Example: [Protocols]
TCPIP=c:\sqlprot\tcpip.prt
[Colors] Section
Default: QUERY and LOAD determine the default value depending on the text color setting and the window background used.
Purpose: Determines how to represent highlighted text used in QUERY and LOAD.
Modify: Use the editor to edit the file.
Example: [Colors]
Bright=Red
[User] Section
Default: <Windows directory>\SQL-DB.INI
Purpose: Determines the name of the file in which the user specifications are saved. It can be used to read the user specifications from a file other than SQL-DB.INI (e.g., on floppy disk) and to save it there.
Modify: The line must be the first line entered in the [User] section. Use the editor to edit the file.
Example: [User]
File=A:\myuser.fil
[Environment] Section
Purpose: Determines the runtime options for precompiler programs (for the syntax, consult Chapter Special Features).
Modify: Use the editor to edit the file.
Example: [Environment]
SQLOPT=-X -F %DBROOT%\prot\pctrace.prt
[Connect] Section
The [Connect] section determines the reference to the ADABAS communication DLL used. It serves internal purposes and should therefore not be changed.
Default: sqllwp.dll
Purpose: Determines the ADABAS communication DLL used for communication via the LAN WorkPlace V4.1 DLL "wlibsock.dll".
Example: [Connect]
LAN-WP=sqllwp.dll
Default: sqlwsa.dll
Purpose: Determines the ADABAS communication DLL used for communication via Windows Sockets 1.1.
Example: [Connect]
WINSOCK=sqlwsa.dll
[Hosts] Section
The [Hosts] section determines the reference to the TCP/IP communication used. It serves internal purposes and should therefore not be changed.
Default: The entries are made automatically on each connect to a [Hosts] name so far unknown. The reference used is the first entry found in the [Connect] section.
Purpose: Makes the reference between the node name of the database server and the TCP/IP communication used.
Modify: This section should not be changed under normal circumstances. The entries are made automatically on each connect to a [Hosts] name unkown so far. The reference used is the first entry found in the [Connect] section.
Example: [Hosts]
sqlserv1=WINSOCK
sqlserv2=WINSOCK