how can i pull up a query which was previously stored in qmf
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 |
What is the physical storage length of time data type?
What language is db2 written in?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is meant by a unit of recovery?
How to check last update on table in db2?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is subquery ?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
wht steps we need will coding cobol and db2 pgm ?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What can the SET option of the Repair Utility accomplish?