SAP Knowledge Base Article - Preview

2397180 - SAP IQ. What should be done when query incosistent result is suspected

Symptom

What actions required when a query inconsistent result is suspected?

Examples.

  • Query displays zero rows whereas one or more rows are expected.
  • A value does not match the query condition
  • Query with "ISNULL(xx, xx)=" , "col=NUll", "col<>NUll" conditions
  • Query with zero-length condition (col='')

 


Read more...

Environment

SAP IQ

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

Sybase, sp_iqcheckoptions, sp_iqcheckdb, NoExec, Row_Count; inconsistent result, unexpected result , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.