How to Retriev and Display a Saved Query?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute a query in qmf at a particular time?

639


How to List the Available Tables?

1344


How to Clear a Query Using the RESET Command ?

1287


What is qmf?

637


What are Naming Standards in QMF?

1330






How to Create a Prompted Query?

1431


What are Naming Conventions in QMF?

1513


How to Build a Row Condition?

1380


How the interaction between DB2, SQL, and QMF takes place?

1210


How to Save a Query?

1263


How to Provide Column Names Using the DRAW Command ?

1193


How to Get Information About the Tables?

1272