2.4.1 Running sql.acu From the Command Line

To use the sql.acu utility to create an empty table and grant access privileges to other users, type:

     runcbl sql.acu

The program will pause to accept an SQL command. Enter the following (italics indicate variable names, non-italics are SQL reserved words):

     CREATE TABLE newtab (col1 CHAR(30), col2 CHAR(11))

The program will pause to accept an SQL command. Now enter the following command:

     GRANT ALL PRIVILEGES ON newtab TO PUBLIC

The program will pause to accept an SQL command. Now enter:

     CREATE UNIQUE INDEX newtab_index ON newtab (col1)

Next, press <Enter> again to exit the program. When naming columns and tables, make sure to use underscore ("_"), not hyphen ("-"), or a syntax error will result.

The above entries will create a new table and grant access permission to everyone. If you want to delete the table you created, enter the following command:

     DROP TABLE newtab