Define

The Define() step is where specific data definitions are established by your application and/or process. This involves defining columns/fields and creating the tables/files with optional indices.

Below is the code for Define():

DROP PROCEDURE Define;

CREATE PROCEDURE Define()

BEGIN

   SQLIStatement cm = new SQLIStatement (

      "CREATE TABLE custmast (" +

         "cm_custnumb CHAR(4), " +

         "cm_custzipc CHAR(9), " +

         "cm_custstat CHAR(2), " +

         "cm_custrtng CHAR(1), " +

         "cm_custname VARCHAR(47), " +

         "cm_custaddr VARCHAR(47), " +

         "cm_custcity VARCHAR(47))"

   );

   cm.execute();

   SQLIStatement cmi = new SQLIStatement (

      "CREATE UNIQUE INDEX cm_custnumb_idx ON custmast (cm_custnumb)"

   );

   cmi.execute();

END

-- Define

ECHO DEFINE;

CALL Define();

COMMIT WORK;