View previous topic :: View next topic
|
Author |
Message |
rinkubhat
New User
Joined: 13 Sep 2005 Posts: 35 Location: India
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
May be the data is not refreshed in your another region. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
The 100 is not necessarily an error. . . . |
|
Back to top |
|
|
rinkubhat
New User
Joined: 13 Sep 2005 Posts: 35 Location: India
|
|
|
|
The Data is there looks like in where clause the host variables are not fecthing proper values.Dont know why? |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
William Thompson The solution which you posted is for same SQL 100 and same original poster rinkubhat |
|
Back to top |
|
|
rinkubhat
New User
Joined: 13 Sep 2005 Posts: 35 Location: India
|
|
|
|
i have it resolved thanks a lot |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|