Can I add SQL DATE,TIME and TIMESTAMP type columns without using SQL?

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Can I use DDOL (Datadictionary Online CICS transaction) to add SQL type columns such as SQL-DATE,TIME and TIMESTAMP columns?

Environment

z/OS CA Datacom 14.0

Resolution

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.

Additional Information

For the list of possible Datacom column Data Types  , see the online documentation here