PLB_SQLIO_INIT Keyword

9.7A

PLB_SQLIO_INIT={sqlcommand}

This keyword specifies a SQL command that initializes a SQL database engine when a SQLIO connection occurs. The SQL initialization command is sent exactly as specified by the {sqlcommand} string. The SQLIO initialization keyword may include the name of the database being connected. The keyword is formatted as follows:

Formats:

PLB_SQLIO_INIT={SqlCommand} //Uses the 'Default' database

PLB_SQLIO_INIT_dbname ={SqlCommand} //Uses the user 'dbname' database

Where:

dbname

The name of the database as specified in the Sun_Sqlio_Databases table or the static default database name of "Default" when the '_dbname' syntax is not used.

Examples:

PLB_SQLIO_INIT={SqlCommand

PLB_SQLIO_INIT_UserDatabase={SqlCommand}

{SqlCommand}

A SQL database initialization string as specified by the user. The user is responsible for ensuring that the {SqlCommand] syntax is correct and can be accepted by the SQL database.

Note the following:

1. The SQLIO operations are implemented to execute SQL statements to simulate PL/B native IO. Successful simulation depends on expected behaviors and SQL expression processing for a database engine.

2. The SQLIO operations are not implemented to replace PL/B DBxxxxx statements and associated behaviors.

3. If the SQLIO initialization keywords result in unexpected SQL table behaviors, the PL/B developer and user are responsible for those behaviors. Sunbelt will not modify the SQLIO PL/B IO simulation algorithms to accommodate unexpected SQL table behaviors caused by a user specified SQLIO initialization command.

See Also: PLBWIN Keywords, PLBCE Keywords, PLBLinux Environment Variables, Compiler and Runtime Options