How can you display the current date & current time ?
Answer Posted / raghu
select currentdate,currenttime from sysibm.sysdummy
the above date and time are scalar functions and it from the timestamp
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a storage group (stogroup)?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the use of dclgen in db2?
Define db2.
What is ibm db2 client?
What is dclgen (declaration generator)?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Is ibm db2 open source?
What is the reason behind not using select * in embedded sql programs?
What is database alias db2?
What is the maximum length of sqlca?
What is meant by dclgen?
What is view db2?
How do I delete a column in db2?