What if , we failed to mentioed null indicator in sql
select query , that may retrieve null value ?

Answers were Sorted based on User's Feedback



What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ..

Answer / 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

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ..

Answer / santy

it will retrive the garbage value.

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More DB2 Interview Questions

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


What is package in db2 mainframe?

0 Answers  


When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  


what is difference between Plan and Package

1 Answers   Syntel,


What is db2 bind?

0 Answers  






What is the maximum size of a char data type in db2?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


What is a storage group (stogroup)?

0 Answers  


Is the primary key a clustered index?

0 Answers  


How to select the duplicate rows from a table?

4 Answers  


Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


Categories