Column Map Procedures

The following syntax is used to generate a statement for each exported Column Map Procedure.

CREATE CMPROC identifier.name 
   [DESC //description//] 
   TEXT //columnmapproceduretext//

Keywords

The text keyword in a Column Map Procedure is followed by SQL statements and Optim™ Basic specified for the specific procedure. For complete information, see Column Map Procedures.

CMPROC
Specify the name of the Column Map Procedure
identifier.name
The two-part name of the Column Map Procedure name.
DESC
Describe the content or purpose of the Column Map Procedure.
//description//
The 1 to 40 character description of the Column Map, delimited by double slashes.
TEXT
Allow you to write the desired Column Map Procedure.
//columnmap proceduretext//
The text that comprises the procedure.