Access Service User's Guide DirectConnect for AS/400

Specifies the file that the sp_sqlgetinfo system procedure uses for target database information.

SQLInformationFile=filename

0-128 characters

as400.sif

filename is the file with sp_sqlgetinfo information.

During installation, DirectConnect places a default copy of the SQL information file for each access service library into the econnect\servername\cfg directory, where servername is the name of the DirectConnect Server. If this property is left blank or not changed, the default file is used.
To customize the file, first make a copy of the default file, save it under a new file name, and then edit the custom file by following these rules:
- Do not modify the header section of the file.
- Begin comments with a semicolon (;) or crosshatch (#) in column 1, on a line by themselves.
- Add additional properties to the [Start SQLGetInfo] section of the file in the property=value format as follows:
- SQL_ACTIVE_CONNECTIONS=0
- Save the file.
To use the custom file, you must enter the custom file name as the SQLInformationFile property value.
If you move the custom file to a directory other than the econnect\servername\cfg directory and want to use the file, enter the full path and custom file name as the SQLInformationFile property value.


	Expand Search