Re: Microsoft OLE DB for DB2 driver issue

[CRPence <CRPbottle@xxxxxxxxx>]

On 12 Nov 2012 10:56, J Franz wrote:
> Our network side is testing the DB2OLEDB (SQL Server 2008 R2) in
> place of the iSeries Access OLE DB driver and one big issue...
>
> The SQL request is handled by QRWTSVR where the iSeries Access went
> through QZDASOINIT.
>
> In the result sets, all the character fields have the trailing blanks
> (fixed length, not trimmed) where as the iSeries Access OLE DB result
> sets were trimmed.
>
> Any idea how this is controlled? Too many apps to modify. V6R1 w/cume
> 1256

  Web search: "oledb" "incorrout" "variable length"

  A _possibly_ relevant hit:
SE38028 - CA400EXP-IDB2DATA-INCORROUT VARCHAR LENGTH REPORTED 2 BYTES 
TOO LONG
http://www.ibm.com/support/docview.wss?uid=nas237e818ee96991651862575cc003c7213
"...
PTFs Available

R610 SI42423 PTF Cover Letter   1000
"

  The 1000 means "not on a cumulative"

  FWiW: R540 equivalent: SE39539 ​