Keyword

This keyword ...

PLB_SQLIO_HOST={hostname}

defines the initial or default SQL database source that is connected when executing SQLIO operations. The {hostname} string is unique to the SQL database engine that is connected. If this keyword is not specified, the runtime looks for the PLB_SCHEMA keyword to get a default SQLite database source. If the PLB_SCHEMA keyword is not found, the runtime uses the runtime default SQLite database source named 'sunschema.db' that is located with the runtime executable. The explicit behavior invoked by this keyword is the same as described for the {host} parameter in the DBCONNECT instruction.

PLB_SQLIO_USER={username}

defines the username used when making the database connection. This keyword may or may not be required to make a connection. The explicit behavior invoked by this keyword is the same as described for the {user} parameter in the DBCONNECT instruction.

PLB_SQLIO_PASS={password}

defines the password for the user when making the database connection. The explicit behavior invoked by this keyword is the same as described for the {pass} parameter in the DBCONNECT instruction.

PLB_SQLIO_CONN={login}

defines additional login information that may be needed to make the database connection. The explicit behavior invoked by this keyword is the same as described for the {conn} parameter in the DBCONNECT instruction.

PLB_SQLIO_EXT={extension}

defines optional extension data that specifies some unique parameters used during the connection process. The explicit behavior invoked by this keyword is the same as described for the {ext} parameter in the DBCONNECT instruction.

PLB_SQLIO_FLAGS={flags}

defines any special settings used to make the connection. The explicit behavior invoked by this keyword is the same as described for the {flags} parameter in the DBCONNECT instruction.

PLB_SQLIO_DRIVER={driver_number}

defines a driver number that identifies the type of SQL connection. The {driver_number} is a numeric value that specifies the SQL database connection type. If this keyword is not specified in the configuration INI file, the {driver_number} defaults a value of one (1).

1 = SQLite native connection

2 = DBFILE connection

PLB_SQLIO_SQLTYPE={sql_language_number}

defines the type of SQL syntax. If this keyword is not specified, the {sql_language_number} defaults to a value of one (1). This keyword is required to ensure proper execution of SQL statements to perform the PLB IO instructions relative to a specific SQL database engine type.

1 = SQLite language type

2 = SQL Server language type

3 = MYSQL language type

4 = Oracle language type

PLB_SQLSCHEMADB={dbname}

defines a schema database name found in the Sun_Sqlio_Databases SQLIO system table. This keyword defines the database name where current schema information is to be accessed and retrieved. The SETMODE *SQLSCHEMADB keyword allows a program to define the current schema database name under program control.

PLB_SQLTABLEDB={table_dbname}

defines a schema database name found in the Sun_Sqlio_Databases SQLIO system table. This keyword defines the database name where the current applicaton SQL data tables are accessed and used. The SETMODE *SQLTABLEDB keyword allows a program to definet the current schema database name under program control.

PLB_SQLIO_DEBUG_LOG={logname}

is only used when debugging issues for the SQLIO support. The {logname} is a file name with path where the runtime writes SQL statements that are executed when performing the PLB IO instructions. If the leading character for the {logname} is a '>' character, only SQL statement execution errors are appended to the log file. If the leading character for the {logname} is a '+' character, all new log entries are appended to the log file.