SQLRegistry Program - update UNIX configuration settings

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"

 

To insert/update a string setting, use the following sequence:

 

./sqlregistry update CONNX.DSNS.mYDSN string "/home/cnxuser/connx/connxclient.sample.cdd; My DSN connections;"