what is SPUFI ?
- 2 Answers
- 7717 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naveen87ginjupalli
SPUFI-SQL Processing Using File Input
spufi is used to executes the SQL quries.
By using spufi we can execute more than one Query at a time
and also we can take the backup.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / girish kumar
Naveen ans is correct and by using SPUFI we can find the
error code in case of query failure situation.
but it is not posssible in qmf.
| Is This Answer Correct ? | 5 Yes | 0 No |
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is the information associated with sysibm.syslinks table?
What r the comman abends in db2, jcl and cobol???????
what is the process of precompiler?
What is buffrpool? Where we use it ?
what is Runstats? Whem will u choose to runatats?
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
How to find the number of rows in a db2 table?
Name some fields from SQLCA
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
When can an insert of a new primary key value threaten referential integrity?
What is check constraint in db2?
COBOL 
