Setting Up the Database

Data Access Getting Started > Introduction > Setting Up the Database

This tutorial uses a database schema with two tables, I_EMP (employee) and I_DEPT (department), that you can set up by either of the following methods:

Use your own database system tools to create the two tables, using the following SQL statements as a model. The statements are based on the SQL2 standard.

I_EMP Table

CREATE TABLE I_EMP (

EMPNO INTEGER NOT NULL,

NAME VARCHAR(25) NOT NULL,

STATUS INTEGER NOT NULL,

DEPTNO INTEGER NOT NULL,

SALARY REAL NULL,

PRIMARY KEY (EMPNO))

I_DEPT Table

CREATE TABLE I_DEPT (

DEPTNO INTEGER NOT NULL,

NAME VARCHAR(25) NOT NULL,

MANAGER VARCHAR(25) NOT NULL,

PRIMARY KEY (DEPTNO))

Use the Data Access SQL Schema Editor delivered with the product to define the tables. See SQL Schema Editor for the procedure to create the tutorial database schema.

Version 6.0