Creating Tables for the TBC Database

Create tables for the TBC database with the same utility program that you typically use to create tables by running SQL scripts.

The standard sample application SQL scripts needed to create tables for the TBC database are in the samples\tbcdbase directory where you installed Integration Server.

The utilities listed in Table 9 have been tested to work with the SQL scripts:

Table 9. Tested Utilities for Creating TBC Tables

Database

SQL Script

Utility Program

IBM DB2

tbc_create_db2.sql
tbc_drop_db2.sql

IBM DB2 Command Window or >DB2 -tvf

Microsoft SQL Server

tbc_create_sqlsrv.sql
tbc_drop_sqlsrv.sql

Query Analyzer

Oracle

tbc_create_oracle.sql
tbc_drop_oracle.sql

  • SQL*Plus

  • SQL*Loader command line utility

Teradata

tbc_create_teradata.sql
tbc_drop_teradata.sql

BTEQ

Each RDBMS has two scripts—one to build tables and another to drop tables.

Caution!

You must create the tables for the TBC database as user TBC, or portions of the standard sample application will not work.

  To create tables for the TBC database:

  1. Start the utility program.

  2. Connect to the TBC database as user TBC.

    Note:

    Use uppercase TBC for Microsoft SQL Server.

  3. In the samples\tbcdbase directory, open the appropriate SQL script file.

  4. Run the SQL script.

    Microsoft SQL Server: You should receive a message that you did not create data or rows. This message is normal because you created only tables and columns.

  5. Verify that you have created the TBC tables; for example, type

    SELECT * FROM PRODUCTDIM

    or start the RDBMS and verify that the TBC database has the new tables.

  6. Close the utility program.