SAP Knowledge Base Article - Preview

3306084 - JCONNECT: query with CASE in the condition returns no rows when using jconn4 - SDK for ASE

Symptom

A simple query as below in java program returns no rows when using jconn4. But it works well when using jconn3.

SELECT a FROM testtable WHERE a =( case when 1=0 then 'XXX' else 'ABCD01' end)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 
  • SAP Adaptive Server Enterprise SDK

Product

SAP Adaptive Server Enterprise SDK all versions

Keywords

CASE, no rows, jconn4, jconn3, dynamic_prepare , KBA , BC-SYB-SDK , SDK , 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.