What do you need to do before you do EXPLAIN ?
Answer / naveen87ginjupalli
The Plan_table is created under the AUTHID.
Is This Answer Correct ? | 5 Yes | 0 No |
What are the advantages of using a PACKAGE?
What does the RUNSTATS Utility do?
Are views updatable ?
What information is contained in a SYSCOPY entry?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is a SELECT statement?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is cursor stability?
What is DCLGEN ?
How will you return the number of records in table?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance