Can I use DDOL (Datadictionary Online CICS transaction) to add SQL type columns such as SQL-DATE,TIME and TIMESTAMP columns?
Yes, you can define such fields in DDOL.
When you define the table in DDOL , you add an SQL-DATE type field as B 4 (Binary data type length 4) , an SQL-TIME type field as B 3 and an SQL-Timestamp type field as B 10 .
You run PF9 APPLY and then you enter UATT(for Update attributes) in the line number at the left on each newly added column and you press PF4 to execute the command.
For that SQL-DATE type column you enter SQL-DATE in SEMANTIC-TYPE followed by PF9 APPLY.
Then PF4 to execute the next UATT command.
Enter SQL-TIME in SEMANTIC-TYPE for that SQL-TIME type field and SQL-STMP for that SQL-TIMESTAMP type field.
For the list of possible Datacom column Data Types , see the online documentation here