SQLIO - Overview

9.5

The Sunbelt Data Manager supports Sunbelt's SQLIO feature. The SQLIO feature allows normal PLB IO instructions(Open, Read, Write) to be used with an SQL database table. Before the SQLIO operations can be performed, user schema information must be provided to specify the record layouts which define the field positions that correspond to a column in a SQL table. The schema files for the SQLIO support must exist on the Data Manager server system where they can be loaded using a SCHEMA instruction.

Definitions

SQLIO

Sub system that allows PLB IO instructions to be executed using SQL language statements to access and manipulate SQL database tables.

SQLIO Schema

Text file in the XML data format that specifies the file names and record layouts associating field names with database columns.

SQLIO System Tables

SQL database tables that contain the schema information used during the execution of PL/B instructions. The system tables are automatically created if they do not exist when SQLIO schema data is being loaded. The SQLIO system tables are named:

• Sun_Sqlio_Afile

• Sun_Sqlio_alias

• Sun_Sqlio_Columns

• Sun_Sqlio_Databases

• Sun_Sqlio_File

• Sun_Sqlio_Ifile

• Sun_Sqlio_Version

Note:

1. When using the 'sundm64' 64-bit Data Manager, the DB interface driver DLLs (SUNWODBC, SUNWMSQL, and SUNWADO) are not supported. Therefore, the 'sundm64' Data Manager does not support SQLIO operations unless the internal SQLite database engine is being used.