Create a conversion table - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-08-20
ft:lastPublication
2024-08-20T21:40:14.000381

Usage

Creates a method that converts shorthand character strings to their full-length equivalents. For example, you can create a method that converts state codes to state names.

Note: In order to use a created conversion table, you have to populate it first.
Syntax
CREATE CONVERSION_TABLE conversion-table
   SOURCE CHAR(length)
   TARGET CHAR(length)
   [ DESCRIPTION ’descriptive text up to 80 characters’ ]
;

Example

File converstables.rsl creates two conversion tables, Department Codes and State Codes, to convert department and state codes into names.
--converstables.rsl
CREATE CONVERSION_TABLE "Department Codes"
   SOURCE CHAR(3)
   TARGET CHAR(20)
;
CREATE CONVERSION_TABLE "State Codes"
   SOURCE CHAR (2)
   TARGET CHAR (20)
;