SQL0901N Error.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bikkaran@in.ibm.com - 27 Feb 2006 11:35 GMT

Hi ,
I received this error message while executing an application

SQL0901N The SQL statement failed because of a non-severe system
error. Subsequent SQL statements can be processed.
(Reason "column number out of range".) SQLSTATE=58004

>From the error message in error help ..I can't find any thing meaning

ful.

Please help me to rectify this.

Regards
Bikash

Reply to this Message

Serge Rielau - 27 Feb 2006 11:53 GMT

> Hi ,
> I received this error message while executing an application
[quoted text clipped - 7 lines]
>
> Please help me to rectify this.

Call support. That's what it says in the message text.
-901 is a DB2 detected, internal bug.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

bikkaran@in.ibm.com - 27 Feb 2006 12:40 GMT

hi ,
Isn't their any other way out. than calling the support .

Reply to this Message

Serge Rielau - 27 Feb 2006 12:47 GMT

> hi ,
> Isn't their any other way out. than calling the support .

Can you produce a repro script. We also need db2level output.
I can take a peek and see if I find a workaround.
BUT. I do that on an "as I find time" and "if I remember" basis.
No PMR, no SLA :-)

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

bikkaran@in.ibm.com - 28 Feb 2006 11:23 GMT

Hi Serge.

I have found out where would have been the mistake.

Actually I was working on a cataloged database which has a version
7.2.0 and the local database installed on the machine was of 8.2.2.
When I ran the same application on local database (both of these
are same except of the version at amount of data ) My application
worked .
It didn't gave me any error.

But still I am not sure , how to rectify if in future I get the same.

Thanks a lot for your guidance. :)
Bikash

Reply to this Message