SQLIO - Getting Started

9.5

To implement the SQLIO feature in the Sunbelt runtime, perform the following three steps:

1. Add a DM_SQLIO_HOST, DM_SQLIO_DRIVER, and DM_SQLIO_SQLTYPE keyword to the SUNDM CFG file. These keywords specify the database source, driver type, and SQL language syntax type used to make a connection to a SQL database engine.

 

2. Define the record layout and create a SQLIO XML schema file. See the SQLIO - Administrative Tables section for more information. The SQLIO XML schema file must be located on server where the Data Manager is executing.

 

3. Modify a PLB program as follows:

 

A. Load a SQLIO schema using the SCHEMA instruction where the Data Manager redirection is used. The SQLIO schema only needs to loaded once or as needed when SQLIO schema updates are required.

 

Example:

 

$DMNAME DIM 100

         MOVE "default|127.0.0.1", $DMNAME

         SCHEMA $DMNAME, IMPORT="myschema.xml", FLAGS=10

or

        SCHEMA $DMNAME, IMPORT="myschema.xml", FLAGS=12

 

B. Modify the OPEN and/or PREP instructions to include the <SQL> tag with or without attributes keywords and include the redirection '|' data to access the Data Manager. The <SQL> tag identifies that a database table is being accessed at the Data Manager. The <SQL> tag is included in the file name fields of the instructions and it must be followed with the '|' redirection to access the Data Manager.

 

Example:

 

xI IFILE

.

         OPEN xI, "test.isi<sql>|127.0.0.1"

or

         OPEN xI,"test.isi<sql Database=AddressData>|127.0.0.1"

or

         PREP xI, "test.txt","test.isi<sql>|127.0.0.1", "5", "10"

or

         PREP xI,"test","test<sql Template=mytemp>|127.0.0.1","5","10"

 

C. Compile and execute the PLB program to access a Data Manager.