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 |
How can you classify the locks in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is load replace in db2?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What is the use of db2 optimizer?
Is ibm db2 free?
How can you quickly find out the number of rows updated after an update statement?
Can a array declared with an index be displayed(readable format) in spool?
Give the name of some fields form sqlca.
What is null value in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?