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 a host variable?
What is meant by a unit of recovery?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
What are db2 tables?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is the latest version of ibm db2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How many databases are there?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
Can SQL statements/queries be included in a copybook?
Explain about rct in db2?
List down the types of triggers in the db2 database?