Example output (Oracle Entry Wizard)
(*
* Entry: Customer
* SQL Table: CUSTOMER
* Creation date: 18 June 1999
*
* Customer
*)
DEFINE_ENTRY
NAME Customer
MODEL_DOC_STATEMENT WITH
DATA_RETRIEVAL "from CUSTOMER where CUSTOMERNUMBER=:1"
KEY_RETRIEVAL "*NONE"
DEFINE_PARAMETERS
Customer_number NUMERICAL ( 9 0) DATABASE_FIELD "CUSTOMERNUMBER"
END_DEFINE_PARAMETERS
DEFINE_FIELDS
Customer_number NUMERICAL ( 9 0) DATABASE_FIELD "CUSTOMERNUMBER"
Surname C_CHAR ( 31 ) DATABASE_FIELD "SURNAME"
First_name C_CHAR ( 31 ) DATABASE_FIELD "FIRSTNAME"
Initials C_CHAR ( 11 ) DATABASE_FIELD "INITIALS"
Date_of_birth NUMERICAL ( 11 0) DATABASE_FIELD "(to_char(DATEOFBIRTH, 'YYYYMMDD'))"
Date_of_death NUMERICAL ( 11 0) DATABASE_FIELD "(to_char(DATEOFDEATH, 'YYYYMMDD'))"
Gender C_CHAR ( 2 ) DATABASE_FIELD "GENDER"
Marital_state C_CHAR ( 2 ) DATABASE_FIELD "MARITALSTATE"
Partner_number NUMERICAL ( 9 0) DATABASE_FIELD "PARTNERNUMBER"
END_DEFINE_FIELDS
DEFINE_SUBENTRIES
(* Place Sub-Entry Definitions here *)
END_DEFINE_SUBENTRIES
END_DEFINE_ENTRY (* Customer *)