Interested to Buy Any Domain ? << Click Here >> for more details...
What if , we failed to mentioed null indicator in sql
select query , that may retrieve null value ?
- 2 Answers
- 9225 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / santy
Sorry for the above answer :(
Please see the Correct answer, we will get the SQL error -
305
-305:- The NULL value cannot be assigned to output host
variable number because no indicator variable is specified.
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
What is scrollable cursor in db2?
How do I add a column in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dbrm? What it contains? When it will be created?
What is the result of open cursor statement?
Explain dclgen.
What is lock escalation in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain the contents that are a part of dclgen.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
List out the three types of page locks that can be held.
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is difference between alias and synonym in db2?
What is copy pending and check pending in db2?
