Joined: 09 Oct 2006 Posts: 12 Location: Chennai, India
Hello,
Code:
SQL +
DECLARE CURSOR1 CURSOR FOR +
SELECT A, B, C, D, +
E, F, G, H, +
I, J, K, +
L, M, N +
FROM TABLE1 +
WHERE DATE = :TODAYS-DATE AND +
STATUS = 'X' AND +
USER_ID <> 'ABC' AND +
NUM_DTL IN +
(SELECT DISTINCT(NUM_DTL) FROM TABLE2 +
WHERE +
DATE = :TODAYS-DATE AND +
TYPE = 'J' AND +
USER_ID <> 'ABC') +
UNION ALL +
SELECT A, B, C, D, +
E, F, G, H, +
I, J, K, +
L, M, N +
FROM TABLE3 +
WHERE DATE = :TODAYS-DATE AND +
STATUS = 'X' AND +
USER_ID <> 'ABC' AND +
NUM_DTL IN +
(SELECT DISTINCT(NUM_DTL) FROM TABLE2 +
WHERE +
DATE = :TODAYS-DATE AND +
TYPE = 'J' AND +
USER_ID <> 'ABC') +
ORDER BY A, +
B, +
M, +
N
The appropriate variables are declared as per the data type requirements.
When I fetch the above, the response is: SYSTEM ABEND CODE 0C4.
Where as when I remove ANY ONE of the columns and their corresponding host variable in the fetch, the program runs successfully.
All these columns are essential to me and I can't remove any of these.
- Is there any limitation on the no. of columns that can be fetched ?
- Is there any limitation on the no. of "continuation" that can be used ?
Pls let me know what could be the reason behind it and how to solve this.