Use the parameters listed in the following table to control how you connect to a specified database.

If you use the Physical Database Name (-db) parameter to specify more than one database when you start a session, specify the connection parameters for each database after the database name to which they apply and before the next -db parameter. OpenEdge applies database connection parameters only to the previously specified database. For example: 

mpro [ -db]db1-name[db1-parameters ] -db db2-name [db2-parameters ]
Note: OpenEdge implicitly specifies the -db parameter for the first database.

You can specify all other parameters anywhere on the command line. If you specify the same parameter more than once, OpenEdge uses the value you provide for the last instance of the parameter.

Syntax Parameter Purpose
-1 Single-user Mode1 Starts OpenEdge in single-user mode
-B n Blocks in Database Buffers1 Specifies the number of database buffer blocks
-B2 n Blocks in Alternate Buffer Pool1 Specifies the number of buffers in the database Alternate Buffer Pool
-Bp n Private Read-only Buffers Requests a number of private read-only buffers
-brl Bleeding Record Lock Holds a share lock on a released record used by more than one buffer
-cache filename Schema Cache File Reads the database schema from a local file instead of the database 
-cp {com-parms|filename}
 Communications Parameter File Overrides preset connection parameters for auto-connect databases
-crStatus n Crash Recovery Status Controls how often a crash recovery status message is displayed
-crTXDisplay Crash Recovery Transaction Display Displays the transaction table during crash recovery.
-cs n Cursor Size Changes the maximum number of index levels
-ct n Connection Retry Attempts Defines the number of retries when connecting to a database
-db physical-dbname Physical Database Name Identifies one or more databases to connect to at startup
-dbalt1 "dbname [-H hostname] -S port" Alternate Database 1 Specifies an alternate OpenEdge database to connect to, in the event that the connection to the primary database (database specified by -db) fails
-dbalt2 "dbname [-H hostname] -S port" Alternate Database 2 Specifies an alternate OpenEdge database to connect to, in the event that the connection to the primary database (database specified by -db) fails
-DataService data-service DataService Connects through a NameServer to an ODBC or Oracle DataServer
-directio Direct I/O1, 2 Opens all files in unbuffered mode
-dt db-type Database Type Identifies the database type
-F Force Access Allows access to a damaged database. Call Technical Support before using -F. 
-H host-name
Host Name Identifies a remote host
-hash n Hash Table Entries1 Specifies the number of hash table entries for the buffer pool
-i No Crash Protection1 Runs OpenEdge without database integrity or recovery
-ipver Internet Protocol Specifies the Internet Protocol version
-is AS/400 Ignore Stamp Stops a client from comparing time stamps when connection to an AS/400 database
-ld logical-dbname Logical Database Name Assigns the logical database name
-Mf n Delayed BI File Write1, 2 Delays writing the last before-image (BI) file records
-Mm n Message Buffer Size Specifies the message buffer size for network client/server protocols
-nohostverify No Host Verify Turns off host verification for a Transport Layer Security (TLS) connection
-nosessionreuse No Session Reuse Avoids the reuse of a Transport Layer Security (TLS) session ID
-P password Password3 Specifies a user password
-Passphrase Prompt for Passphrase1 When connecting to a database enabled for Transparent Data Encryption, specifies that the user must be prompted for the key store passphrase
-r Non-reliable I/O1 Enables buffered I/O to the before-image file
-requireusername Require name Requires users starting servers of the AdminServer to provide a valid username and password
-retryConnect retry-count Retry Connect Set Specifies the number of times to retry connecting to a set of OpenEdge databases (primary and alternates), before giving up
-retryConnectPause pause-interval Retry Connect Set Pause Specify how long to wait (in seconds) before attempting to reconnect to a set of databases (primary and alternates specified by -dbalt1 and -dbalt2)
-RO Read-only Media Opens a database for read-only access 
-S { servicename |port-number }
 Service Name Identifies the service and port number to use on the host machine when connecting to a broker process
-Sn AS/400 Server Program Name Specifies that the Server program on an AS/400 start with an OpenEdge connection request (SNA only)
-ssl TLS-based Connection Specifies a Transport Layer Security connection 
-trig {dir-name|lib-name}
 Trigger Location Identifies the directory or library containing the ABL triggers for a database
-U userid User ID3 Specifies the user ID 
jdbc:datadirect:openedge://<ip>:<port>;
  databaseName=<dbname>;
  truncateTooLarge=<on/all/output/off>;
 truncateTooLarge With its value set to ON or ALL, the parameter allows truncating data exceeding the column size and all operations will be performed on truncated data. If the value is set to OFF, no data is truncated and an error is displayed. If the parameter is set to OUTPUT, all operations occur on data that is not truncated and truncation is performed only on the output and truncation only happens for columns exceeding maximum size. The default value for the 
truncateTooLarge
parameter is OFF. If a value is not specified for this parameter, the value set in the server startup parameter is used.
1 Single-user database connections only; otherwise, use only for server startup.
2 UNIX, Windows only.
3 Different meaning for non-OpenEdge databases.