SQLIO Database Engine Notes

9.5

Listed below is database specific information regarding use with SQLIO.

SQLite

  1. PLB TRANSACTION SAVE/TRANSACTION RESTORE is not supported when using the SQLite database engine to perform the SQLIO operations.

    2.  

  2. If the PLB_SQLIO_DRIVER is set to a DBFILE connection, all database notes documented for a DBCONNECT instruction apply.

 

SQL Server

  1. A SQL Server administrator needs to create and maintain any databases that SQLIO uses for a PLB application. If the SQL Server administrator does not create an application database, everything goes to the default that has been defined by the administrator for a connection.

    2.  

  2. If the PLB_SQLIO_DRIVER is set to a DBFILE connection, all database notes documented for a DBCONNECT instruction apply

 

MYSQL

  1. A MYSQL administrator needs to create and maintain any databases that SQLIO uses for a PLB application. If the MYSQL administrator does not create an application database, everything goes to the default that has been defined by the administrator for a connection.

    2.  

  2. If the PLB_SQLIO_DRIVER is set to a DBFILE connection, all database notes documented for a DBCONNECT instruction apply

 

ORACLE

  1. An ORACLE administrator needs to create and maintain any databases that SQLIO uses for a PLB application. If the ORACLE administrator does not create an application database, everything goes to the default that has been defined by the administrator for a connection.

  2. If the PLB_SQLIO_DRIVER is set to a DBFILE connection, all database notes documented for a DBCONNECT instruction apply.

 

See Also: SQLIO Overview, SQLIO Getting Started

 


PL/B Language Reference SQLIO Limitations SQLIO Supported Tables