Creating a Database

The HPL loads data into an existing table in an existing database. The examples in this chapter load the information from the file /work/mydata into a three-column table named tab1 in a database named testdb. You can use DB–Access to prepare the database and table, as follows:

CREATE DATABASE testdb;
CREATE TABLE tab1
(
   col1 INTEGER,
   col2 CHAR(1),
   col3 INTEGER
);
GRANT ALL ON tab1 TO PUBLIC;
GRANT CONNECT TO PUBLIC;

After you finish preparing the database for the examples, exit from DB–Access.