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 to find last record before record through SQLRPGLE?

1 Answers   IBM,

Update command

1 Answers  

When will you chose to run RUNSTATS?

1 Answers  

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

What is cursor?

2 Answers  

what is load and unload in db2

1 Answers   IBM,

Can we delete records from view?

0 Answers  

Are views updatable ?

4 Answers  

What is the use of predicate?

0 Answers  

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

For more DB2 Interview Questions Click Here
Categories