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 |
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is the use of commit in db2?
What is a composite index and how does it differ from a multiple index?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is db2 bind?
Explain the function of data manager.
How can we define a table? How can we apply SEARCH ALL on it ?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
can we drop column from a table
what are the SQL codes u freequently got?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
Discuss about db2 bind?