How can you display the current date & current time ?
SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;
Is This Answer Correct ? | 5 Yes | 0 No |
Explain the function of data manager.
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is REORG? When is it used?
how we will do null data selection in cobol-db2 program
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
How to insert more than one record using insert?
What are the contents of dclgen?
What are iseries servers?
Q4. How will you get the count of record without using COUNT verb in query?
What is a LIKE table and how is it created?
where will u check for sqlcode ?
What is IMAGECOPY ?