Rational Developer for System z

Creating the sample table

To create a sample table, which will be accessed by the sample stored procedures, do the following steps:

Procedure

  1. Right-click the Tables folder of your schema and select New -> With SQL Editor.
  2. 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) );
  3. Right-click the white space in the editor and click Run SQL. The Data Output view should indicate a successful run.
  4. Close the SQL editor without saving the contents.
  5. Right-click the Tables folder and click Refresh The new table definition appears in the Tables folder of your schema.
    Column name Column type Length
    CITY VARCHAR 32
    COUNTRY VARCHAR 32

Feedback