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 |
Can there be more than one cursor open for any program?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
difference between group clause and order clause
How to access db2 tables in mainframe?
What is reorg and runstats in db2?
Is schema the same as database?
When will you chose to run RUNSTATS?
What are the disadvantages of using VARCHAR?
What is a Resource Control Table(RCT)? Describe its characteristics.
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
How to restart a DB2 program?