I have been successful in using COM.ibm.db2.jdbc.net.DB2Driver (v8.1) to access a stored proc from BIRT. It is bringing back data in preview results. from the stored proc

Then I tried doing a plain sql to bring back id nos to demo BIRT to other developers who will be using BIRT. I saved my changes and had my settings set to only bring back 10 records. There is data, because I used Quantum DB to make sure data was out there using the same jdbc driver . So I executed the sql from BIRT via the preview results.

The preview results indicates it returned 10 records. The preview shows the Column name but the data for the 10 records found isn't being displayed. I have uploaded the results. This only happens with this driver.

what is the column type? If you select * from the first table only do
you get results?

Jason

On 7/23/2012 11:53 AM, Carlos Ferrer wrote:
> Database: DB2 for Z/OS ver 9.1
> BIRT ver 3.7.2
> JDBC Driver: COM.ibm.db2.jdbc.net.DB2Driver (v8.1)
>
> I have been successful in using COM.ibm.db2.jdbc.net.DB2Driver (v8.1) to access a stored proc from BIRT. It is bringing back data in preview results. from the stored proc
>
> Then I tried doing a plain sql to bring back id nos to demo BIRT to other developers who will be using BIRT. I saved my changes and had my settings set to only bring back 10 records. There is data, because I used Quantum DB to make sure data was out there using the same jdbc driver . So I executed the sql from BIRT via the preview results.
>
> The preview results indicates it returned 10 records. The preview shows the Column name but the data for the 10 records found isn't being displayed. I have uploaded the results. This only happens with this driver.
>
> Thanks for your help.
>

The column type is char(08). There are valid records, because when I run the same sql with a type 2 jdbc driver, the 10 records come back with data when I do a preview. I am trying to make sure we stick to one jdbc driver instead of having to mix 2 jdbc drivers.

I can't use the type 2 across the board because I get a stored procedure error that I don't get with tye type 3 jdbc driver.

On 7/26/2012 10:42 AM, Carlos Ferrer wrote:
> Sorry, was out 2 days.
> The column type is char(08). There are valid records, because when I
> run the same sql with a type 2 jdbc driver, the 10 records come back
> with data when I do a preview. I am trying to make sure we stick to one
> jdbc driver instead of having to mix 2 jdbc drivers.
> I can't use the type 2 across the board because I get a stored procedure
> error that I don't get with tye type 3 jdbc driver.
>
> Thanks.