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 a collection in db2?

0 Answers  


What is a cursor?

2 Answers  


How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,


What are common abends

1 Answers   SPIC, Virtusa,


What is db2 optimizer?

0 Answers  






What are the rules for db2 programming?

0 Answers  


What information is held in SYSIBM.SYSCOPY?

1 Answers  


why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,


what is dynamic cursor?gives syntax for this?

1 Answers   TCS,


How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


Categories