Interested to Buy Any Domain ? << Click Here >> for more details...
What is SPUFI?
- 4 Answers
- 17467 Views
- I also Faced
- E-Mail Answers
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 does DB2 use multiple table indexes?
What is the role of the data page in the db2 database?
How to get the ddl of a table in db2?
Describe the elements of the SELECT query syntax?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
is it possible to get -811 error when you use cursors. why?
pls tell me abt the normalization five types....
When is the results table for the query in a DECLARE CURSOR statement created?
Which isolation level provides highest data integrity?
Explain about rct in db2?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
COBOL 
