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.
Note: When naming columns and tables, make sure to use underscores ("_"), not hyphens ("-"), or a syntax error will result.
  1. From a command prompt enter:
    ccbl sql.acu
  2. Enter the following (italics indicate variable names, non-italics are SQL reserved words):
    CREATE TABLE newtab (col1 CHAR(30), col2 CHAR(11)) 
  3. Enter the following command:
    GRANT ALL PRIVILEGES ON newtab TO PUBLIC 
  4. Now enter:
    CREATE UNIQUE INDEX newtab_index ON newtab (col1)
  5. Press Enter to exit the program.
You should now become familiar with the Demonstration Program.