Create a database

The loads data into an existing table in an existing database. The examples in this section load the information from the file /work/mydata into a three-column table named tab1 in a database named testdb. You can use DB-Acess 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;