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

book

Article ID: 17134

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- 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