1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.
Answer / santy
we will get the sql code "-305".
-305:- The NULL value cannot be assigned to output host
variable number because no indicator variable is specified.
| Is This Answer Correct ? | 8 Yes | 0 No |
What does CURRENTDATA option in bind indicate
What do you need to do before you do EXPLAIN ?
What does the CHECK Utility do ?
What is the use of dclgen in db2?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
wht are the restrictions for union ?
Give some example of statistics collected during RUNSTATS?
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....
How do you stop a db2 database in linux?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How is deadlock resolved?
What Utility is used to migrate DB2 from one release to the next?