The DataServer (-Dsrv) startup parameter allows you to use special DataServer options to tune your environment. You pass these options as arguments to -Dsrv when connecting to a MS SQL Server database.

There are two versions of the syntax, as follows:

Syntax

CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1 -Dsrv arg2,val2 -Dsrv arg3,val3...
 
CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1,arg2,val2,arg3,val3...

In this syntax:

  • The schema holder is already connected.
  • The data-source-name argument is the name of the data source and the logical-name argument is its logical name, which is defined when you create your schema image.
  • You pass the options as the argn,valn pairs.

Here is an example of how to use the CONNECT statement with the -Dsrv parameter:

CONNECT mssql_db -ld mydb -U x -P y
   -Dsrv qt_debug,EXTENDED
   -Dsrv PRGRS_IDBUF,100
   -Dsrv PRGRS_MINBUF,10000
   -Dsrv MAX_R,10000.

Note that MAX_R is an abbreviation of MAX_ROWS. You can abbreviate option names as long as they identify parameters uniquely.

Both the syntax statements and the example show the use of the -Dsrv startup parameter in CONNECT statements. You can also specify -Dsrv options in a parameter file, on a program item command line, or in the Connection Parameters field in the Database Connect dialog box.