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 |
What is host variable in db2 cobol?
What is dbrm? What it contains? When it will be created?
What if we fail to give values in columns declared as NOT NULL ?
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.
What is meant by union and union all?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
Can you define an Index if the table size less than 10 PAGES?
What is a buffer in memory?
what is the difference between join and union?
What is plan in cobol db2?
Are views updatable ?
What is read-only cursor?