A Column Map Procedure is a custom program written in Optim™ Basic that is referenced to perform special processing or data manipulation that is otherwise beyond the scope of a Column Map.
The function of a Column Map Procedure is generally the same as that of an exit routine. Exit routines, however, are written outside Optim and must be externally compiled and linked. Column Map Procedures are written within Optim.
The \Samples\CMProc subdirectory includes sample files written in Optim Basic that can be used to create a set of Column Map procedures. The file names are:
This task describes how to create a Column Map Procedure from a provided file.
To create a Column Map Procedure from one of the files provided:
A Standard procedure is called to derive the value for a destination column in a Column Map. This sample Column Map procedure is created from the CMExit.bas file provided.
This procedure performs two operations on the sample database table OPTIM_CUSTOMERS, as follows:
To use this sample in a Column Map, you must specify PROC CMEXIT.BAS in the source column for the destination column SALESMAN_ID.
The sample table information Column Map procedure is created from the TBLINFO.BAS file. This sample is provided to demonstrate the Optim Basic Column Map procedures that you can use to retrieve data about a process, product or database table.
This procedure moves unchanged source data to the destination, and demonstrates how to output the following: