Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is an inner join, and an outer join ?
How do we specify index to include or not during bind process.
Why do we use cursor?
What is meant by isolation level?
How do you check for a null value in a db2 column?
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?
How to see the structure of db2 table??
In terms of DB2 indexing, what is the root page?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is a storage group (stogroup)?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is db2 stogroup?