View previous topic :: View next topic
|
Author |
Message |
xsray
New User
Joined: 16 Sep 2008 Posts: 19 Location: illinois
|
|
|
|
We have a random number generator program that is called by the on-line transactions. This program fetches and updates the next available number from a DB2 table. The on-line transactions always come back with the number and never a -904. We recently installed a batch program that also calls the random number generator, but it is plagued with -904s. Has anyone experienced this and resolved it? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
what does the manual say about a -904 error code ?
read the manual and act accordingly to it' s suggestions |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Also, "random number" and "next available number" seem to be contradictory. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi xsray,
Please post full error text with the reason code.
Sushanth |
|
Back to top |
|
|
Lijo
New User
Joined: 24 Aug 2008 Posts: 41 Location: Cochin
|
|
|
|
As said look into the Manual. Look for the REASON CODE (an 8 character value in the error message, like REASON 00C90084) under -904 SQLCODE. -904 can happen due to various reasons. Follow the instructions under 'User Response'. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
look at what the random number generator program does.
It probably updates/inserts some value in some table.
Replace this with db2 sequence. |
|
Back to top |
|
|
|