Author Topic: Less records fetched with sybase native driver  (Read 1315 times)

Offline yousuf_248

  • Full Member
  • ***
  • Join Date: Jun 2009
  • Posts: 10
  • Forum Citizenship: +0/-0
Less records fetched with sybase native driver
« on: 16 Jul 2009 10:27:33 am »
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.

Offline DustPanMan

  • Community Leader
  • *****
  • Join Date: Aug 2005
  • Posts: 138
  • Forum Citizenship: +8/-0
Re: Less records fetched with sybase native driver
« Reply #1 on: 22 Jul 2009 11:29:43 am »

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,