Add new code table entry

book

Article ID: 108850

calendar_today

Updated On:

Products

CA 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