Creating a sample table

Before you create a COBOL or PL/I stored procedure, you must create a sample table that the stored procedure can access.

Procedure

  1. Right-click the Tables folder of your schema.
  2. Select New > SQL File Editor.
  3. Change the text in the editor to the following, replacing mysche with the name of the schema folder:
    CREATE TABLE mysche.CITYTABLE (
CITY CHAR(32) NOT NULL, 
COUNTRY CHAR(32) NOT NULL, 
PRIMARY KEY(CITY) );
  4. Right-click the white space in the editor and click Run SQL. The Data Output view indicates a successful run.
  5. Close the SQL editor without saving the contents.
  6. Right-click the Tables folder and click Refresh. The new table definition is added to the Tables folder of your schema.
    Column name Column type Length
    CITY VARCHAR 32
    COUNTRY VARCHAR 32