If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Less records fetched with sybase native driver

Started by yousuf_248, 16 Jul 2009 10:27:33 AM

Previous topic - Next topic

yousuf_248

Hi All,

I have found some strange thing. I am developing reports using cognos 8.2. Db used is Sybase 15.0.3. I created a data source using Sybase CT Lib and tried to create a report.
Here comes the problem...i tried pulling a field whose type is "CHAR" and size defined for that is 100. I have roughly 4000 records in DB, but my report is pulling only 1200 records. If i pull any other field(size of which is less than or around 50) i get all records. Is there any size limit for Sybase CT Lib to fetch data from DB?

I tried work around and created another data source with type as "ODBC" and tried running the report. It fetched all the records.
I have three restrictions from customer

1)Data source using ODBC cannot be used
2)DB admin is not ready to limit the size of field.
3)Display of that field in the report is a must.

Can anyone suggest us work around to get all the records using native driver and without limiting the size of column in DB?

Thanks in advance.

DustPanMan

Yousuf,

This is happening because blank rows are ignored.  If you pull a key column with this one, you will likely get all of your records.

Best regards,

Dustin
Best,

D