Print Page - cognos SQL V/S Pass through SQL

Title: cognos SQL V/S Pass through SQL
Post by: ari_meta on 09 Mar 2010 08:09:26 PM

Hi

I am extracting BLOB into Varchar. I am using pass through SQL on the oracle database. Please suggest me what kind of performance issue, i may have, for using pass through SQL in place of native SQL .
can any one suggest me other ways to convert blob to varchar . I have unsuccessfully created determinants , used CAST function etc.

Thanks

Ari

Title: Re: cognos SQL V/S Pass through SQL
Post by: MFGF on 10 Mar 2010 11:35:22 AM

Hi,

The difference between Native and Passthru SQL is that C8 does not parse and modify a Passthru query at all - just runs it as-is with no validation. There may be a performance hit if the query does not return a valid projection list that can be used - in this case, local processing will be done to provide this from the result set.

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: ari_meta on 09 Mar 2010 08:09:26 PM