cognos SQL V/S Pass through SQL

[ari_meta]

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

[MFGF]

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.