Product Documentation

FairCom Java Stored Procedures

Previous Topic

Next Topic

Define

Define() establishes specific data definitions. This involves defining columns/fields and creating the tables/files with optional indexes.

Below is the code for Define():

DROP PROCEDURE Define;

CREATE PROCEDURE Define()

BEGIN

SQLIStatement st = 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))"

);

st.execute();

END

-- Define

ECHO DEFINE;

CALL Define();

TOCIndex