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?
No Answer is Posted For this Question
Be the First to Post Answer
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
what is a corelated subquerry?
What are the functions of Bind?
What is bind and rebind in db2?
What is the role of schema in the db2 database?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How does coalesce work?
Plan has the optimized access path in it. But is that optimized access path is attained or known
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to restart a DB2 program?
How can you count the number of rows from a table tab?
what are the SQL codes u freequently got?