Field specification section - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:19:56.898694

The Field Specification section of a script contains any Commands that alter field attributes, define variables, set date formats, initialize target field values, etc. The following commands are included in the Field Specification section.

  • DECLARE – defines a Global variable accessible in to all Procedures, user defined Functions and the Main Processing Section.
  • EXTTYPE – specifies the format of the data found in a field. For example, EXTTYPE can be used to specify that the numbers found in a numeric field represent dates.
  • INITIALIZE – initializes a target field to a constant value.
  • INVALID – sets the default value to use when invalid data is found in a source field.
  • LABEL – assigns a label to an XML field. This label is used in the XML tags for that field.
  • RETYPE – redefines the attribute of a source field (i.e. numeric to character).