Re: SQL problems with old V2R1 program

["Jim Franz" <franz400@xxxxxxxxxxxx>]

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/db2/rbafzmstcksql.htm
is the sqlcode search
952  - you need reason code to determine problem.
jim

----- Original Message ----- 
From: "Dan Rasch" <drasch@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, August 25, 2004 11:25 AM
Subject: SQL problems with old V2R1 program


>
> We just spent yesterday isolating an SQL problem that confounded
> our staff, and turned my cubicle into something like a Turkish prison.
>
> We have an old program used to receive downloads from a mainframe
> that uses SQL and was originally written back in 1992, under V2R1.
> Sometime between midnight and 4AM, the program started issuing these
> messages:
>
> Pointer not set for location referenced.
> Exception recursion detected.
> Application error. *N unmonitored by *N at statement *N, instruction
>   X'4000'.
> Function check.  CEE99901 unmonitored by DEIAPIC at stetement 194,
>   instruction X'007C'.
> Processing of the SQL statement ended.  Reason code 7.
>
> The dump showed the SQLCODE was -952
>
> I remember reading a thread from a year or more back that some Version 2
> programs would not run under the new Version (I think it was V5R1) - but
> could not recall a specific problem with SQL.  The program is SQL/COBOL.
> We looked under every rock I knew of, and failing to isolate it
> better, eventually just sent the customer a version compiled at Version 5.
> This worked, but there are potentially many more customers who could
> experience the same problem.
>
> Has anyone seen a similar problem?
> If needed, I could provide the DECLARE CURSOR, FETCH and UPDATE
> statements privately.
>
> TIA,
>
> Dan Rasch - because if the human species concentrated on the really
> important things in life, there would be a shortage of fishing poles!
> IBM Certified twice....... but still a couple PTFs away from Nirvana.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>