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
 

 

Getting an SQl code 100 in one of the online programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
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    Post subject: Getting an SQl code 100 in one of the online programs
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    Post subject:
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

Site Director


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

PostPosted: Thu Jun 28, 2007 1:18 pm    Post subject:
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    Post subject: Hi
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: 3158
Location: Tucson AZ

PostPosted: Thu Jun 28, 2007 2:47 pm    Post subject:
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    Post subject:
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    Post subject: hi
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: 3158
Location: Tucson AZ

PostPosted: Thu Jun 28, 2007 3:23 pm    Post subject: Re: hi
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

Site Director


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

PostPosted: Thu Jun 28, 2007 7:48 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


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