Populate a conversion table - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Usage

Adds name and value combinations to a created conversion table.

Note: Both the name and value are defined as literal strings and must be enclosed in single quotes.
Syntax
POPULATE CONVERSION_TABLE conversion-table
   ( ‘exact-name’ = ‘result-value’) }
   , ...
;

Example

File converstables.rsl created in the previous example now includes the statements to populate the conversion tables "Department Codes" and "State Codes."
--converstables.rsl
CREATE CONVERSION_TABLE "Department Codes"
   SOURCE CHAR(3)
   TARGET CHAR(20)
;
POPULATE CONVERSION_TABLE "Department Codes"
   (‘100’ = ‘Payroll’),
   (‘200’ = ‘Marketing’)
   (‘300’ = ‘Accounting’)
;
CREATE CONVERSION_TABLE "State Codes"
   source char (2)
   target char (20)
;
POPULATE CONVERSION_TABLE "State Codes"
   (‘MA’ = ‘Massachusetts’),
   (‘NH’ = ‘New Hampshire’)
;