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

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


Please Help Members By Posting Answers For Below Questions

When the like statement is used?

879


What is the max length of sqlca?

961


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

848


How to create backup table in db2?

847


How to restart a DB2 program?

1583


How do I delete a table in database?

779


What is db2 connect?

791


Can one database have multiple instances?

792


Explain in brief how does db2 determine what lock-size to use?

778


How can we retrieve the total number of records in RPG & CLLE?

371


Is ibm db2 open source?

811


What is bind and rebind in db2?

876


What is query_cache_limit?

748


What is bind package and plan in db2?

801


Mention the location where the output received from explain statement is stored.

851