1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.



1. what if null values retrived from database and no null indicator mentioned in query. What is sq..

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

Post New Answer

More DB2 Interview Questions

What is commit in db2?

0 Answers  


What is sqlca?

0 Answers  


what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,


How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


Explain what are the various isolation levels possible?

0 Answers  






What is index cardinality?

3 Answers  


What is null indicator in cobol db2?

0 Answers  


Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


When do you specify the isolation level? How?

1 Answers  


What is the reason behind not using select * in embedded sql programs?

0 Answers  


what is consistency token

3 Answers  


Categories