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’)
;