What is SPUFI?
Answers were Sorted based on User's Feedback
Answer / ramesh m
SPUFI used to write the query to select, insert, update or
delete the rows for particular acct in DB2 tables. this
will be used in any of the release or deployment. we can
select this utility from DB2 Interactive Menu. The
advantage in using this tool is we can do the multiple
perform in one SPUFI file. The output will be created with
the status of query run.
| Is This Answer Correct ? | 6 Yes | 2 No |
How Plan is created while executing the query using SPUFI?
What is bind in db2?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What does sqlcabc has?
What is db2 and what is the use of db2 optimizer?
What is the difference between drop table and delete table?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
what is SMP/E? and what are the major steps of it? thanks...
What is dbrm? What it contains?
Explain how can you do the explain of a dynamic sql statement?
What is query_cache_limit?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records