Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / mangesh

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

How are write I/Os from the buffer pool executed?

1 Answers  

What is database manager in db2?

0 Answers  

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

Which is faster delete or truncate?

0 Answers  

What is a db2 collection?

0 Answers  

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

what is rebinding ?

1 Answers   IBM,

what are the bind parameters?

5 Answers   IBM,

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

What is Reorg Recovery? when will you run it?

2 Answers  

For more DB2 Interview Questions Click Here
Categories