The data file can come from a variety of sources including a program that generates the data or a tool that extracts the data from some other database. As you can see from the options available in the configuration file, you have considerable flexibility in the form that the data file can take. However, the following guidelines must be followed:
-
No quotes (single or double) are to be used around any of the data including character data types, CLOBs, date, time, and datetime fields.
-
Date, time, and datetime fields must not have the DATE, TIME, or DATETIME keywords preceding the values (as described in the MCPSQL Programming Guide for bound parameters).
Date, time, and datetime fields in the data file must be expressed in the format described for those data types. Refer to the MCPSQL Programming Guide for details on these data types.
