IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Getting an SQl code 100 in one of the online programs


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rinkubhat

New User


Joined: 13 Sep 2005
Posts: 35
Location: India

PostPosted: Thu Jun 28, 2007 1:11 pm
Reply with quote

I am getting an SQl code 100 in one of the online programs.The program is working fine in test region but in Another region it is giving the SQl code 100 .I tried the query in spufi for the region and it is fetching proper vales.Dont know how can this be solved.
I even dont have access to run the program in the given region.Any help??
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Jun 28, 2007 1:15 pm
Reply with quote

May be the data is not refreshed in your another region.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 28, 2007 1:18 pm
Reply with quote

Hello,

The 100 is not necessarily an error. . . .
Back to top
View user's profile Send private message
rinkubhat

New User


Joined: 13 Sep 2005
Posts: 35
Location: India

PostPosted: Thu Jun 28, 2007 1:31 pm
Reply with quote

The Data is there looks like in where clause the host variables are not fecthing proper values.Dont know why?
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Thu Jun 28, 2007 2:47 pm
Reply with quote

Try this possible solution:
SQL code 100 in an online program
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Jun 28, 2007 3:10 pm
Reply with quote

William Thompson The solution which you posted is for same SQL 100 and same original poster rinkubhat
Back to top
View user's profile Send private message
rinkubhat

New User


Joined: 13 Sep 2005
Posts: 35
Location: India

PostPosted: Thu Jun 28, 2007 3:11 pm
Reply with quote

i have it resolved thanks a lot
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Thu Jun 28, 2007 3:23 pm
Reply with quote

rinkubhat wrote:
i have it resolved thanks a lot
And would you be kind enough to let us (and others who follow with the same problem) know what the resolution was?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 28, 2007 7:48 pm
Reply with quote

Hello,

As mentioned earlier, the +100 is not necessarily an error.

From the Fine Manual
Quote:
+100 ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY
IS AN EMPTY TABLE

What this means is that the code needs to be corrected to check for the ROW NOT FOUND condition.

The 100 has nothing to do with online or batch. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
Search our Forums:

Back to Top