SAP Knowledge Base Article - Preview

3442890 - Query with cast function is not returning expected results - SAP IQ


  • A query that had been working suddenly stopped returning results.  The html is creating many plans with no data.
    SELECT CAST(CASE WHEN EXISTS(SELECT * FROM tclient cl JOIN tclient2 map ON cl.fid = map.fid WHERE cl.fcode = 'INFO' AND map.fsid = 3) THEN 1 ELSE 0 END AS BIT) as available   
  • This is preventing reports that were previously created in seconds, to not being created at all.
  • No errors in the IQMSG nor the SRVLOG.
  • Would like to know why this is failing.



SAP IQ 16.1


SAP IQ 16.0


KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.