Interested to Buy Any Domain ? << Click Here >> for more details...
how can i pull up a query which was previously stored in qmf
- 3 Answers
- 11274 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / piyush mani
I think there is no way to fetch previous queries in qmf it can b done in spufi.
wt ur feed back.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / prabhas
if you know the mainframe user id where you have stored the
query , then give command LIST ALL and press enter it will
show you all the query stored in that user id.
please post the correct answer if i am wrong....
| Is This Answer Correct ? | 2 Yes | 2 No |
How can record locking be achieved in those DB2 versions which do not support it?
What is the maximum size of a char data type in db2?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
How many databases are there?
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.
Explain what are the various isolation levels possible?
What is a buffer pool?
What is an instance in db2?
What parameters are used to control the free space in DB2?
Mention the downsides of page level lock.
What is subquery ?
COBOL 
