Lesson 6: Editing Workbench generated code table SQL

You can also edit the generated Code Table SQL to tweak the initial values for the Code Table.

1. In the Project Explorer View, locate the DemoModule project and navigate to the DemoModule/resources/sql/db2 folder.
2. Double-click on the DemoModule_CODETABLES_DB2.sql file to open it in the SQL editor, and navigate to about the middle of the file.
3. Locate the following four SQL statements used to add values into the CDTERMSOFPAYMENTTYPESTP table:

   INSERT INTO mdm_development_test_one.CDTERMSOFPAYMENTTYPESTP ( lang_tp_cd, tp_cd, name , description, last_update_dt, last_update_user ) 
      VALUES ( 100, 1, 'name1' , NULL, CURRENT TIMESTAMP, 'cusadmin' );
   
   INSERT INTO mdm_development_test_one.CDTERMSOFPAYMENTTYPESTP ( lang_tp_cd, tp_cd, name , description, last_update_dt, last_update_user ) 
      VALUES ( 100, 2, 'name2' , NULL, CURRENT TIMESTAMP, 'cusadmin' );
   
   INSERT INTO mdm_development_test_one.CDTERMSOFPAYMENTTYPESTP ( lang_tp_cd, tp_cd, name , description, last_update_dt, last_update_user ) 
      VALUES ( 100, 3, 'name3' , NULL, CURRENT TIMESTAMP, 'cusadmin' );
   
   INSERT INTO mdm_development_test_one.CDTERMSOFPAYMENTTYPESTP ( lang_tp_cd, tp_cd, name , description, last_update_dt, last_update_user ) 
      VALUES ( 100, 4, 'name4' , NULL, CURRENT TIMESTAMP, 'cusadmin' );

4. Edit the default values 'name1', 'name2', 'name3', and 'name4' to change them to '15 Days', '30 Days', '45 Days', and '60 Days' respectively.
5. Press Ctrl+S to save.