Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / a
What vamshi is said is incorrect .i.e he told about
RUNSTATS utility.
Where in REORG is used to re organise the table after huge
manipulation say insert,delete of records etc.It provides
free space also.
Correct me if i wrong vamshi/anyone
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the function of data manager.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How to check sequence on a table in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the difference between cursor and select statement?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Mention the definition of cobol in varchar field.
What's The Percentage Free Space ?
Can you use max on a char column?
How to find the maximum value in a column in the db2 database?
How will you return the number of records in table?
What is table space in db2?
Is it possible using max on a char column?
What is the difference between using bind () and rebind () methods of naming class?
Why select is not preferred in embedded sql programs?
