Updating UNIX Configuration Settings with the SQLRegistry Program
A SQLRegistry executable file (.exe) is installed on your machine when you install the CONNX client component on UNIX.
After the installation process is complete, export the CONNXREGISTRY environment variable (CONNXREGISTRY = /home/cnxuser/connx/connxclient/connxreg.db) into your UNIX environment. Each UNIX system may have a slightly different export method.
Note:
The CONNXREGISTRY configuration setting (environment variable) is required and referenced by the CONNX client component and the JDBC Server program to access the registry file.
The SQLRegistry program is a command-line program. To run the program, proceed to the directory where the program is installed on your machine without passing an additional argument, for example, "/sqlregistry".
A menu is displayed:
1. Display registry keys and values
2. Create a registry key value
3. Update registry key value
4. Delete registry key value
5. Exit Program
You may also pass additional argument(s) when you run this program. To learn the usage, type "./sqlregistry help". The following messages will be displayed:
Usage ./sqlregistry: [Registry file,] (option) 1|2|3|4
, Key, (datatype) 0|1|2, Value
option: 1=display, 2=create, 3=update,
4=delete, 5=create_or_update
datatype: 0=integer, 1=string, 2=binary
For example, to display the settings stored in the registry file, type:
"./sqlregistry display" or "./sqlregistry 1" (without quotes)
Use the following sequence to insert/update a string setting:
./sqlregistry update CONNX.DSNS.mYDSN string "/home/cnxuser/connx/connxclient.sample.cdd;
My DSN connections;"