B37 abend during SPUFI ?
The b37 abend in the SPUFI is because of space requirements , the query has resulted in so many rows that the SPUFI. out file is not large enough to handle it, increase the space allocation of SPUFI out file.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
My program has an array defined to have 10 items. Due to a bug, I find that even if the program access the 11th item in this array, the program does not abend. What is wrong with it ? 27.08.08
Must use compiler option SSRANGE if you want array bounds checking. Default is NOSSRANGE....What do you do to resolve SOC-7 error ? 31.07.08
Basically you need to correcting the offending data. Many times the reason for SOC7 is an un-initialized numeric item. Examine that possibility first. Many inst...What are common SQL abend codes ? 25.07.08
-818 time stamp mismatch -180 wrong data moved into date field...What is SPUFI? 28.03.08
SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects....What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2? 21.03.08
There are three ways in establishing tso/db2 connection 1. SPUFI 2. QMF 3. CATALOG VISIBILITY B. A thread between TSO & DB2 is established while attempting...How would you print the output of an SQL statement from SPUFI ? 16.03.08
Print the output dataset....In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned ? 16.03.08
+100 (for successful completion of the query), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes)....How do you do the EXPLAIN of a dynamic SQL statement ? 13.03.08
There are two methods to achieve this: 1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement 2. Include EXPLAIN command in the embedded dynamic SQL stateme...What is EXPLAIN? 13.03.08
EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement) or in BIND s...What is meant by AUTO COMMIT? 07.03.08
AUTO COMMIT is a SPUFI option that commits the effects of SQL statements automatically if they are successfully executed....