How do we specify index to include or not during bind
process.
No Answer is Posted For this Question
Be the First to Post Answer
List down the types of triggers in the db2 database?
List down the data types in the db2 database.
How to fetch the last row from the table in SQL (db2)?
What is query_cache_limit?
What is SPUFI?
How does DB2 store NULL physically?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is the difference between oracle and db2?
Can we able to find all the Table names under a Particular Plan?