Column Text in DDS and DDL tables

Column Text in DDS and DDL tables
Column Text in DDS and DDL tables, dds to ddl, dds to sql, column text, as400,ibmi, db2, sql, db2 for i sql, database modernization
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

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain