Interested to Buy Any Domain ? << Click Here >> for more details...
How Plan is created while executing the query using SPUFI?
- 3 Answers
- 8743 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Plan is already created during the installation of the DB2I
tools.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / arun chinnadurai
A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mangesh
No Plan is get created while executing the query using
SPUFI. SPUFI , QMF are only tools to check the correctness
of your query , i.e where ur query is correct or u have
coded anythig wrong .
| Is This Answer Correct ? | 6 Yes | 7 No |
How to resolve -818 sql code in DB2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How does DB2 store NULL physically?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
Is ibm db2 free?
What are the contents of a DCLGEN?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
How to test SQL -911 error while developing COB-DB2 program
How is the value function used?
why we create view.
Mention some fields that are a part of sqlca.
COBOL 
