Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 12902 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / chandrika
Exec sql
set :ws-current-date to current date
End exec
display 'current date' ws-current-date.
Exec sql
set :ws-current-time to current time
End exec
display 'current time' ws-current-time.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the difference between using bind () and rebind () methods of naming class?
What is scrollable cursor in db2?
What is the purpose of rollback and commit?
How does a cursor work?
Define predicate?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the meaning concurrency in the db2 database?
What are the contents of dclgen?
How do I optimize a query in db2?
How connect db2 database to datastage?
Which component is responsible for db2 startup and shutdown?
Why select is not preferred in embedded sql programs?
How to retrieve rows from a db2 table in embedded sql?
What is ibm db2 connect?
