Add new code table entry

Products

• Repository

Issue/Introduction

How do we add a new value to code table D48 which is assigned to the FUNCTION field on the SQL COL entity? Specifically, we would like to add ENCRYPT as an option in this pick list.

Environment

Release: DATASH00200-7.2-Repository-Webstation Option
Component:

Resolution

To insert a new value named ENCRYPT into the D48 code table (or any code table for that matter) you can run an INSERT statement to add the new entry.
For example,

INSERT INTO repowner.DBX_CODE_VARIANCE       
(CODE_TBL,CODE_5,CODE_10,CODE_NUM,CODE_DESC,
LOW_VALUE_NUM,HIGH_VALUE_NUM)              
VALUES                                     
('D48','ENC','ENCRYPT',0,'ENCRYPT',0,0)    
;                                           
COMMIT;       

Note.
Change repowner to your repository creator