Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 13137 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Define sqlca.
What is copy pending and check pending in db2?
What's The Error Code For Unique Index Voilation?
What does reorg do in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How do I add a column to a table in db2?
What is the use of db2 optimizer?
What is the use of db2?
How do I create a view in db2?
What does a deadlock mean in DB2?
Define predicate?
Mention the downsides of page level lock.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is alias in db2?
