Variable

Description

AutoCommit

FALSE to have normal recoverable transaction processing take place at CONNECT time. TRUE to turn off normal recoverable transaction processing. The default is FALSE.

AutoQuote

Specifies whether single quotation marks are automatically placed around a string specified in the Expression 2 box in the Where Criteria window in the Query or Select painter. When the option is 1 (the default), quotes are automatically applied to a string in the Expression 2 box (if you didn't enter quotes yourself). When the option is 0, quotes are not applied.

Columns

The number of table or view columns that display when you expand a table. If the number of columns in the table exceeds the specified number, a vertical scrollbar displays so you can scroll to display all the columns.

Database

The name of the default database.

DatabasePassword

The database password you use.

DBMS

The name of your default database management system vendor (one of the vendors specified in Vendors).

DbParm

Database dependent.

ForeignKeyLineColor

The RGB value of the color you want to use for the line between the foreign key symbol and the table. The default is blue.

IndexKeyLineColor

The RGB value of the color you want to use for the line between the index symbol and the table. The default is red.

PrimaryKeyLineColor

The RGB value of the color you want to use for the line between the primary key symbol and the table. The default is green.

Prompt

1 to prompt for database information when you connect to a database, 0 (the default) to turn off the prompt. This option is typically set in the Database Profile Setup window.

Lock

The isolation level. Database dependent.

LogId

Your logon id.

LogPassword

Your password.

NoCatalog

Catalog access. No to create the repository tables automatically the first time a user connects to the database using PowerBuilder.

Yes to allow DDL and DML (CREATE, INSERT, or DELETE) statements. If the repository tables do not exist, PowerBuilder does not create the repository tables. If the tables exist, PowerBuilder will not reference the tables. The default values will always be used.

The default is No.

ReadOnly

Database access. When this variable is set to 0, PowerBuilder will create the repository tables automatically the first time a user connects to the database using PowerBuilder.

When this variable is set to 1 and the repository tables do not exist, PowerBuilder does not create them; the default values are used. If the tables exist, PowerBuilder will use the tables but will not allow users to modify information in the tables.

ServerName

The name of the server.

ShowIndexKeys

0 to not display the index keys and 1 to display them.

ShowReflnt

When this option is 0 referential integrity is not painted in the Database Painter (that is, foreign keys, primary keys and the lines associated with them). When the option is 1 (the default), referential integrity is painted.

StayConnected

Option to start the database transaction the first time a painter requests it and close the transaction only when you exit PowerBuilder. The default is1 stay connected, 0is close the transaction when you leave the painter.

TableDir

Option to suppress display of the table list. When TableDir is 1 (the default), PowerBuilder automatically lists the tables in the current database when you open the Database Painter. When TableDir is 0, PowerBuilder does not display the table list when you open the painter. To open a database table when TableDir is 0, click the Tables icon . A dialog box displays, select the name of the database table you want to open and click Open.

TableSpace

Database dependent. See the appropriate database interface manual for more information.

TerminatorCharacter

The character used to terminate a SQL statement.

UserID

Your user ID.

Vendors

The name of your DBMS vendor (for example, Gupta, Oracle, or Sybase). Specify each DBMS to which you have access; enter the default vendor first and separate vendors with commas.