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 |
If I have a view which is a join of two or more tables, can this view be updatable?
Who uses db2?
What do you mean by rollback?
Explain the function of data manager.
How do I add a column in db2?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
How do you check for a null value in a db2 column?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What are bind parameters in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is index cardinality?