Loading Data into the TBC Tables

Load data into the TBC tables by running an SQL script using the same utility program that you typically use to load tables by running SQL scripts.

The utilities listed in Table 10 have been tested to work with SQL scripts.

Table 10. Tested Utilities for Loading Data into TBC Tables  

Database

SQL Script

Utility Program

IBM DB2

sampledata.sql

IBM DB2 Command Window or >DB2 -tvf

Microsoft SQL Server

sampledata.sql

Query Analyzer

Oracle

sampledata.sql

SQL*Plus

Teradata

sampledata.sql

BTEQ

  To load data into the TBC tables:

  1. From the command line, move to the samples\tbcdbase directory where you installed Integration Server.

  2. Start the utility program.

  3. Connect to the TBC database as user TBC.

  4. In the sample\tbcdbase directory, open the sampledata.sql script file.

  5. Run the SQL script using your RDBMS tool.

  6. Verify that you have loaded data into the TBC tables; for example, type

    SELECT * FROM TBC.PRODUCT

    or start the RDBMS and execute a query.

  7. Close the utility program.