Everything previously discussed for DATABASE, PROFILE, INPUT, OUTPUT, and PROCESS parameters also applies for the add and replace functions. Differences arise in the way EDIT parameters are processed.
For TYPE=CREATE, the EDIT parameters specified the SQL column definitions that are generated. The field name becomes the new SQL column name; the sequence of EDIT parameters define the SQL column sequence; and the CA Culprit data specification becomes the SQL data type.
For TYPE=ADD and TYPE=REPLACE, the EDIT parameters are compared against an existing SQL table definition and validated. E level errors result if the CA Culprit data specification differs from the known SQL data type.
|
Copyright © 2014 CA.
All rights reserved.
|
|