Column Text in DDS and DDL tables

Column Text in DDS and DDL tables

The column text is the text provided to each file field when making the file fields to understand the field.

Column Text in DDS

In DDS files column heading can be added using TEXT at field level.

To define the column text we should use the TEXT('column text') with the file field.

A          R RDDS5                                           
A            FLD1          10A         TEXT('FIRST TEXT FLD') 
A            FLD2           2P 0       TEXT('FIELD2')        
A          K FLD1                                            

And when we see the above code column text

Column Text in DDL

In DDS files column text can be added using LABLE ON at field level.

To define the column text we should use the FieldName TEXT IS 'Column Text' with the file field.

CREATE TABLE DDL5 (                           
  FLD1 CHAR(10) NOT NULL WITH DEFAULT , 
  FLD2 DECIMAL(2) NOT NULL WITH DEFAULT       
                  )RCDFMT RDDS5;                           
   LABEL ON DDL5(                             
     FLD1 TEXT IS 'FIRST TEXT FLD',           
     FLD2 TEXT IS 'FIELD2'  );  

And when we see the above code column text

Related Post

Read also :

• CRTPF and Create Table in IBM i
• Primary Key in DDS and DDL tables
• Data Validation in DDS and DDL tables
• Column Heading in DDS Files and DDL tables
• Attributes of DDL table
• Auto-update Timestamp Column using ROW CHANGE TIMESTAMP in DDL table
• ADD Constraint in DDL tables
• Create Index and LF keyed in IBM i
• Create View and LF Non-Keyed in IBM i
• DDS to DDL Modernization : Level Check Error
• Identity column in DDL table
• QSQGNDDL API - IBM to convert DDS file into DDL table
• QSQGNDDL API - IBM to convert DDS file into DDL table (Continuing...)