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 |
How do you find the maximum value in a column in db2?
What is the meaning of -805 SQL return code?
what is a corelated subquerry?
How to resolve -502 sql code in DB2?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
Which catalog tables contain authorization information?
What can the SET option of the Repair Utility accomplish?
If I have a view which is a join of two or more tables, can this view be updatable?
what is cursor stability?
What is a synonym ?
what is the difference between where clause and having clause