Skip to main content
Question

After the custom Attribute - CDB file

  • February 6, 2026
  • 2 replies
  • 28 views
ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14

Hello IFS Community,

After creating a custom attribute using IFS Studio Developer and compiling the .cre file, I have a question regarding the .cdb file creation.

When creating the .cdb file, do I need to copy the entire content of the .cre file, or only the section where the custom attribute is declared?

For example:

DECLARE
   table_name_ VARCHAR2(30) := 'TRANSPORT_TASK_TAB';
   columns_    Database_SYS.ColumnTabType;
   column_     Database_SYS.ColRec;
BEGIN
   Database_SYS.Reset_Column_Table(columns_);
   Database_SYS.Set_Table_Column(columns_, 'TRANSPORT_TASK_ID', 'NUMBER', 'N');
   Database_SYS.Set_Table_Column(columns_, 'PRINTED_FLAG', 'NUMBER', 'N');
   Database_SYS.Set_Table_Column(columns_, 'CREATE_DATE', 'DATE', 'N');
   Database_SYS.Set_Table_Column(columns_, 'NOTE_TEXT', 'VARCHAR2(2000)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'FIXED', 'VARCHAR2(5)', 'N');
   Database_SYS.Set_Table_Column(columns_, 'SPLIT_BY_HU_CAPACITY', 'VARCHAR2(5)', 'N');
   Database_SYS.Set_Table_Column(columns_, 'CREATED_BY', 'VARCHAR2(120)', 'Y');--Custom attribute
   Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
   Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
   Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
-- [END IFS COMPLETE BLOCK]
/

Or Do I need need to copy the entire cre file?

JL

2 replies

CallumW
Superhero (Partner)
Forum|alt.badge.img+16
  • CallumW
  • Superhero (Partner)
  • February 6, 2026

You only need to add the new column.

 

P.s. when customising standard IFS, you should prefix your fields with C_ e.g. C_CREATED_BY

 

Naming and Syntax Guidelines - Technical Documentation For IFS Cloud

 

DECLARE
   table_name_ VARCHAR2(30) := 'TRANSPORT_TASK_TAB';
   columns_    Database_SYS.ColumnTabType;
   column_     Database_SYS.ColRec;
BEGIN
   Database_SYS.Reset_Column_Table(columns_);
   Database_SYS.Set_Table_Column(columns_, 'C_CREATED_BY', 'VARCHAR2(120)', 'Y');
   Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
 

 

 

Update to add more information for completeness/ future IFS Versions

You do not need to copy the indexing / key sections.

25R2 specific: You must copy the creation of the Editioning View as well.

Callum Wells - https://uk.linkedin.com/in/callum-wells - Anthesis https://anthesisglobal.com/
    InfFilipV
    Hero (Partner)
    Forum|alt.badge.img+12
    • InfFilipV
    • Hero (Partner)
    • February 6, 2026

    Hi,
    use this menu for creation of CDB. - so it is safely reexecutable.

     


    never include -- [END IFS COMPLETE BLOCK] in cdbs


    and only include as less as possible, but this is minimum

    DECLARE
       table_name_ VARCHAR2(30) := 'TRANSPORT_TASK_TAB';
       columns_    Database_SYS.ColumnTabType;
       column_     Database_SYS.ColRec;
    BEGIN
       Database_SYS.Reset_Column_Table(columns_);
       Database_SYS.Set_Table_Column(columns_, 'CREATED_BY', 'VARCHAR2(120)', 'Y');
       Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
    END;

     

    Filip | Developer | InfoConsulting.com
      Terms & ConditionsCookie settingsAccessibility statement