How can you display the current date & current time ?
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 syntax for FETCH in DB2 ?
what are bind concepts in db2 cobol?
What is dpf in db2?
What is the maximum length of sqlca?
What is performance tuning db2?
What is the use of reorg in db2?
What is ibm db2 used for?
Explain package in db2 and its advantages?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Mention the various locks that are available in db2.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How to rename a table in DB2 ?
What are the contents of a dclmgen?
Which isolation level provides maximum concurrency?
What is a db2 collection?