Use the parameters listed in the following table to control spawned OpenEdge SQL processes when connecting to a OpenEdge SQL server.

Syntax Parameter Purpose
-classpath SQL Server Java Classpath The pathname of the classpath. Identifies the Java classpath to use when starting an SQL server. SQL database brokers use this parameter when launching the Java Virtual Machine (JVM) to execute stored procedures. The default is to use the current environment variable CLASSPATH setting. You do not use this parameter directly.
-ServerType Type of Server to Start

Limits the type of server the broker can start.

4GL

Indicates the broker supports only OpenEdge servers.

SQL

Indicates the broker supports only SQL servers.

Both

Indicates the broker supports both OpenEdge and SQL servers.

To change the value of -ServerType, use the config.properites file or the command line.
-SQLCursors SQL Open Cursors The number of open cursors per connection. Defines the maximum number of cursors open at any one time. The maximum value is 512, minimum value is 10 and the default value for multi-user is 50.
-SQLQuotedRowid SQL rowid identifier Specify the interpretation of the quoted string "rowid." The default value for both single-user and multi-user is std.

std—Specify std to indicate that all instances of the quoted string "rowid" are interpreted as an SQL identifier (such as a column name).

value—Specify any string other than std to indicate that all instances of rowid, quoted or not, are interpreted as the SQL rowid function.
-SQLStack SQL Stack Size The size, in MB, of the SQL Stack. Changes the size of the SQL stack. n denotes the size of the stack in 1KB units. Minimum value is 1, Maximum value is system dependent, single-user default value is 1 and multi-user default value is 1.
-SQLStmtCache SQL Statement Cache The number of statements allowed in the SQL statement cache. Sets the number of statements that can be stored in the SQL cache. The default multi-user value is 100.
-Ma Maximum Clients per Server The maximum number of remote users per SQL server. The default is the Maximum Number of Users (-n) parameter value, divided by the Maximum Number of Servers (-Mn) parameter value. Maximum value is 2048.
-Mi Minimum Clients per Server Defines the minimum number of remote users per SQL Server before the broker starts another server. Minimum value is 1 and multi-user default value is 1.
-SQLWidthUpdate SQL Autonomous Schema Update Helps resolve the SQL width problem by updating the SQL column width in schema automatically when Authorized Data Truncation (ADT) occurs for data in a column. To use this feature, provide the value of the -SQLWidthUpdate parameter as ON during startup. After the value of the parameter is set, it is remembered for the lifetime of the server and for all connections. If the value of the -SQLWidthUpdate parameter is set to ON during startup, the Authorized Data Truncation (ADT) parameter is also enabled irrespective of whether ADT was enabled during startup unless specified otherwise using connection URL. For more information, see Autonomous Schema Update (ASU)
Note: This parameter can be provided only during server startup and not in the client connection URL.
-SQLTruncateTooLarge SQL Authorized data truncation Truncates the data returned to the user when its size exceeds the column size. Can be set to ON or ALL to truncate data exceeding the column size. If the parameter is set to OFF, no data is truncated and SQL displays an error. If the parameter is set to OUTPUT, only the output is truncated. SQL also displays an error if the SQLTruncateTooLarge parameter is not specified at all in case of data exceeding the column size. The default value for the SQLTruncateTooLarge parameter is OFF. For more information, see Authorized Data Truncation
-SQLLockWaitTimeout SQL - LockWaitTimeout value Use -SQLLockWaitTimeout to specify the number of seconds to wait when a lock conflict occurs. This value applies to all conflicts that occur while using SQL applications. The default value is 5 seconds. For more information, see Lock Wait Timeout
Note: Progress recommends changing the value of Lock Wait Timeout (-SQLLockWaitTimeout) if your installation encounters a lot of conflicts.
-Bt STS only The number of Rocket buffers for temp db. Range is 10 to 10**6. Default value is 32. For more information, see Temporary Directory (-T).
-T Temporary Directory The directory for temp db. Default location is $WRKDIR.

The directory in which to create temporary files.

If you do not use this parameter, OpenEdge creates temporary files in the current working directory.
-t Save Temp Files Indicates whether temp db is linked. By default, this remains unlinked. Typically, temporary files (LBInumber, SRTnumber, PGEnumber, DBInumber, RCDnumber, and TRPnumber) are invisible (unlinked on UNIX) when OpenEdge is running. In these filenames, number is the process ID of the user's OpenEdge session. The -t parameter also makes the entries visible after OpenEdge terminates. However, if OpenEdge terminates, delete the temporary files yourself. For more information, see Save Temp Files (-t).
-SQLAutoStats Autonomous Update Statistics -SQLAutoStats ON/OFF . The default value for single-user and multi-user is OFF
-SQLTempPgSize SQL temporary data page size The size of the temporary table data page. Defines the size of MM datablocks (page size) [unit = 1kb]
-SQLTempBuff SQL Sorting Memory The size of the temporary table buffer in memory. Defines the size in K-bytes of the temporary table buffers in main memory cache