SQLIO Limitations

9.5

Please note the following limitations regarding SQLIO:

 

  1. No support for multiple records types within one file.

    2.  

  2. ISAM keys that do not exist in the record data are not supported. Conditional ISAM keys defined for primary record selection using the 'Px={yy}' key specification are not supported.

    3.  

  3. No partial WRITE/UPDATE operations.

    4.  

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

    5.  

  5. When using UTF16 data required for the SQL_NCHAR or SQL_NCHAR_T types in SQLIO PL/B IO instructions, the normal native disk I/O does not support UTF16 data.

    6.  

  6. PL/B variable length records are not supported. While it is possible to write limited amount of data for a SQLIO record, a read operation returns a full record as defined by the columns configured into the SQLIO schema.

    7.  

  7. SQLIO cannot simulate any PL/B IO operations that use data that cannot be stored and represented in a SQL database as appropriate for the SQL data types being used.

 

 

See Also: SQLIO Overview, SQLIO Getting Started


PL/B Language Reference SQLIO PLB Language Changes SQLIO Database Engine Notes