473,405 Members | 2,445 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Store procedure fails with null exception for SELECT querys for tables with columns >10

Hi,

The storeprocedure fails with null exception on the DB2 development
centre for SELECT querys for all tables that has the number of columns
greater than 10.
Strange ,but true ..i reinstalled DB2 and tried again it still fails.
I cant find anything in db2diag.log ..Is there anywhere else i need to
look??


Any prompt help with this would be greatly appreciated.

Thanks in advance

George

PS : Below is the error and db2level.

ERROR:

DB2ADMIN.TestProc_SP - Run started.
Data returned in result sets is limited to the first 100 rows.
Data returned in result set columns is limited to the first 20 bytes
or characters.
DB2ADMIN.TestProc_SP - Exception occurred while running:
null
DB2ADMIN.TestProc_SP - Roll back completed successfully.
DB2ADMIN.TestProc_SP - Run failed.


Below is the db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL08015" with
level identifier "02060106".
Informational tokens are "DB2 v8.1.5.449", "s040212", "WR21334", and
FixPak
"5".
Nov 12 '05 #1
0 1094

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: George | last post by:
Hi, The storeprocedure fails with null exception on the DB2 development centre for SELECT querys for all tables that has the number of columns greater than 10. Strange ,but true ..i reinstalled...
1
by: Raj Tripathi | last post by:
I am using ACT to stress test a simple (HelloWorld) WebService method. When number of connections is <= 10 everything works just fine. But increasing connections causes Http 403 errors. Whats...
11
by: vips | last post by:
I have a string str="10*12*14" now I want the total of this value i.e. 10 multiply 12 multiply 14 how do i get it ? is there any function in vb.net to do that ?? if i put it as query to...
3
by: Pieter | last post by:
Hi, I have a View which contains (of course) several columns. Now I want to make a Stored Procedure that does a Select based on the parameters. For exemple: One time I want to select all the...
5
sanjay123456
by: sanjay123456 | last post by:
Sir i want that mod operation on gr8ter than 10 bit by following code of C long d,c,b,n; int i; d= 65073305
4
by: barmatt80 | last post by:
I am stumped on the error reporting with sql server. I was told i need to return @SQLCode(code showing if successful or not) and @ErrMsg(and the message returned). I am clueless on this. I...
2
by: laredotornado | last post by:
Hi, How do I write a query where if a column, "value," is NULL I return the phrase "No value entered" but otherwise return the column's value, even if it is the empty string? I'm tried to...
2
by: ssecorp | last post by:
I have seen somewhere that you can write something like: x*x if x>10 but exactly that doesn't work and I can't get any variation to work. it is possible to nest with an else too. how do...
18
by: DaveM | last post by:
On Sun, 27 Jul 2008 05:24:36 -0700 (PDT), alex23 <wuwei23@gmail.comwrote: I've seen the PERL saying/motto/boast, "There's more than one way to do it" derided on more than one occasion on...
2
by: E11esar | last post by:
Hello there. I am going in bit of a circle with this matter; First some background: I am trying to upload the details of a CSV file into an Oracle table. I am using a StreamReader to copy a line...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.