The relational data source for the standard sample application is TBC.
To set up TBC relational data source:
For more information, see Creating the TBC database.
For instructions, see Creating tables for the TBC database.
For instructions, see Loading data into the TBC tables.
Create the TBC database in the same way that you create any database using an RDBMS:
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 DB2 OLAP Integration Server.
The utilities listed in Table 23 have been tested to work with the SQL scripts:
Database | SQL Script | Utility Program |
---|---|---|
DB2 | tbc_create_db2.sql tbc_drop_db2.sql | DB2 Command Window or >DB2 -tvf |
Informix | tbc_create_informix.sql tbc_drop_informix.sql | DBAccess |
MS SQL Server | tbc_create_sqlsrv.sql tbc_drop_sqlsrv.sql | Query Analyzer (MS SQL Server 7.0 and 2000) |
Oracle | tbc_create_oracle.sql tbc_drop_oracle.sql | |
Sybase | tbc_create_sybase.sql tbc_drop_sybase.sql | ISQL |
Teradata | tbc_create_teradata.sql tbc_drop_teradata.sql | BTEQ |
Each RDBMS has two scripts. The first script builds tables and the other drops tables.
To create tables for the TBC database:
MS-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.
Informix: If you run the Informix SQL script (tbc_create_informix.sql) more than once, you must first run tbc_drop_informix.sql to drop tables before you build them again.
SELECT * FROM PRODUCTDIM
Alternatively, you can start the RDBMS and verify that the TBC database has the new 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 24 have been tested to work with SQL scripts.
Database | SQL Script | Utility Program |
---|---|---|
DB2 | sampledata.sql | DB2 Command Window or >DB2 -tvf |
Informix | sampledata.sql | DBAccess |
MS SQL Server | sampledata.sql | Query Analyzer (MS SQL Server 7.0 and 2000) |
Oracle | sampledata.sql | SQL*Plus |
Sybase | sampledata.sql | ISQL |
Teradata | sampledata.sql | BTEQ |
To load data into the TBC tables:
SELECT * FROM TBC.PRODUCT
Alternatively, you can start the RDBMS and execute a query.