1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.
Answer Posted / 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 |
Post New Answer View All Answers
What is a cursor in programming?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
what is the role of the cursor in db2?
What is the usage of open cursor command?
What is the purpose of using commit?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How do I change the column size in db2?
Which component is used to execute the sql statements?
What is the difference between oracle and db2?
What is a db2 table?
Explain in detail about buffer manager and its functionalities?
What is the use of reorg in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What happens in bind step in a db2 program?
is it compulsory commitment control in journal?