Add new code table entry

Document ID : KB000108850
Last Modified Date : 03/08/2018
Show Technical Document Details
Question:
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.
Answer:
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