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

What is a plan and package in db2?

625


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1899


What's The Error Code For Unique Index Voilation?

656


What is db2 connect?

611


How do I add a column to an existing table in db2?

592






What is netezza database?

575


What is the use of commit in db2?

636


Can you tell me how can you find out the # of rows updated after an update statement?

612


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

662


What is drop table?

584


Is ibm db2 open source?

589


Explain what are the various isolation levels possible?

610


How to restart a DB2 program?

1368


How to run db2 command in windows?

654


What are types of indexes?

595