Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Easytrieve - Problem in fetching.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
Sheshadri

New User


Joined: 09 Oct 2006
Posts: 12
Location: Chennai, India

PostPosted: Wed Oct 28, 2009 5:56 pm    Post subject: Easytrieve - Problem in fetching.
Reply with quote

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.

Thanks!
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Oct 28, 2009 6:05 pm    Post subject:
Reply with quote

probably line 3 of your host variable declarations.
Back to top
View user's profile Send private message
Sheshadri

New User


Joined: 09 Oct 2006
Posts: 12
Location: Chennai, India

PostPosted: Wed Oct 28, 2009 6:29 pm    Post subject:
Reply with quote

Could you pls detail? I didn't get the point.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Oct 28, 2009 6:40 pm    Post subject:
Reply with quote

Quote:
Could you pls detail?


you did not, why should I?

you mentioned that when you remove one of the SELECT columns and the host variable, everything is ok.

all you have provided us is some SQL.

are we supposed to psychically know
  1. the data type of the columns
  2. the corresponding Host variables
  3. which column/host variable you removed?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Oct 28, 2009 8:23 pm    Post subject:
Reply with quote

a soc4 is basically a boundary violation - the address at which you are attempting to write does not belong to you.

indexing out of bounds,
bad pointers.

db2 will return a soc4 sometimes, but you have been able to code around that,

so, seeing your 'working storage' and some of the code following the fetch would help us to help you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us