How to Retriev and Display a Saved Query?
Answer / shikha jain
Sometimes you may need to retrieve a saved query from the database for viewing. Suppose you wanted to view the query BASIC_Q previously saved and shared by your userid. To display that saved query, BASIC_Q, from the database, use the following procedure:
• Type DISPLAY BASIC_Q at the “Command” prompt.
• Press ENTER.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many Query Options are there?
How the interaction between DB2, SQL, and QMF takes place?
How to Build a Row Condition?
What is qmf?
How to Create a Prompted Query?
How to Erase a Query?
How to Save Your Profile?
How to List the Available Tables?
What is the Use SHOW Command?
How to Provide Column Names Using the DRAW Command ?
What is Query By Example (QBE) ?
What are differences between QMF and SPUFI?