3-7
keyword are associated with the new starter database (for example, germany.dbs) at that time. Any database that is then created on that server will use the starter database as its basis, and the remembered value of country will be permanently incorporated in that new database throughout its physical lifetime, regardless of how the SQL.INI keywords are altered after start.dbs is created.
You must not change the country setting after database creation, either in the server portion of SQL.INI or the client portion. Doing so would lead to error messages about “invalid codepages”.
If you decide that you wish to safely use a different setting for country, you must unload the affected databases, follow all the steps outlined in Building a database with NLS on page 10-9, then load the contents back into those newly built databases.
Keyword list
The following table lists and provides a brief description of each configuration keyword:
Keyword Brief Description
ansijoinsyntax Indicates whether SQL99 ANSI syntax can be used in queries for purposes of joining tables.
audit Specifies the path and directory name for the audit file managed in the SQL.INI file by the START AUDIT and STOP AUDIT commands.
autostartserverpath Specifies the full name and location of the SQLBase server executable, for use with the WS32, APIPE, and MPIPE protocols.
batchpriority Allows you to change the priority level SQLBase sets for itself. You can lower the priority from the default high priority to “normal” Windows priority level.
cache Specifies the number of pages in the database cache. Page size is 1 kilobyte. Minimum value is 15, maximum is 1,000,000.
centurydefaultmode Changes the two-digit default century values that SQLBase stores in a database.
characterset Identifies a file that specifies different values for the ASCII character set.
clientcheck Instructs the server to send the client a RECEIVE message upon receipt of a request.
clientname Specifies the name that the server displays in the CLIENT NODE field on its Server Status display when a client connects to a database.
clientruntimedir Specifies the location of SQLBase client binary files.
comdll Specifies the communication libraries to load.
commitserver Enables a server to act as the commit server for distributed transactions.
connectpauseticks Number of seconds that the client waits before deciding that an attempt to connect to the server has failed.
connecttimeout Specifies the total time allowed, in seconds, for the client to repeatedly attempt to connect to the server before a timeout message is issued.
country Instructs SQLBase to use the settings in the specified section of the country.sql file.
dbdir Specifies the drives, paths, and directory names for the home database directories.
dbname Specifies a database name and, optionally, communication libraries that clients use to access the database.
dbwin Determines the status of the Databases subwindow.
defaultdatabase Specifies the default database name, overriding the default of ISLAND.
defaultpassword Specifies the default password, overriding the default of SYSADM.
defaultuser Specifies the default user name, overriding the default of SYSADM.
defaultwrite Controls whether changes to the values of the defaultdatabase, defaultpassword, or
defaultuser keywords are written to SQL.INI.
disablelogspacecheck Allows you disable checking for log file space availability before a new log file is opened.
displevel Specifies the level of information (0-4) displayed on the Process Activity window.
errorfile Specifies a file that contains entries to translate standard SQLBase return codes into user-defined return codes.
extdll Specifies the pre-loading of DLLs at server start-up time.
fileaccess Prevents user access to select SQL/API functions.
groupcommit Specifies the maximum number of commits that SQLBase groups together before physically writing them to disk.
groupcommitdelay Specifies the maximum number of system ticks that SQLBase waits before performing a commit.
listenport Identifies the port number on which a server listens for connections.
Keyword list
3-9
locks Specifies the maximum number of lock entries to allocate.
locktimeout Specifies how long to wait when acquiring a lock.
log Writes all the messages that appear on the server’s Process Activity display to a specified file.
logdir Redirects the transaction logs to the specified drive and directory.
logfileprealloc Enables and disables transaction log file preallocation.
mainwin Determines the size and position of the main server window.
maxnestinglevel Specifies the maximum nesting level for recursing stored procedures.
negotiateapi Enables secure 7.1 routers to connect to servers that do not support transmission security.
netcheck Enables and disables a checksum feature that detects transmission errors between a client and a server.
netchecktype Specifies the algorithm SQLBase uses when netcheck is enabled.
numconnectionecb Adjusts the number of connection Event Control Blocks (ECBs).
numlistenecb Used to adjust the number of listen Event Control Blocks (ECBs).
optimizefirstfetch Sets the optimization mode for a result set.
optimizerlevel Determines the optimizing techniques that SQLBase uses for all clients that connect to a server.
oracleouterjoin Turns on and off Oracle-style outer join processing.
osavgwindow Sets the number of samples of the operating system statistics to keep for determining average value.
ossamplerate Sets the frequency at which operating system statistics are gathered.
outmessage Sets the size of the output message buffer.
partitions Enables access to partitioned databases
password Sets a password for the server.
procwin Determine the status of the Process Activity subwindow.
readonly Enables and disables read-only mode for all databases on a server.