SAP Knowledge Base Article - Preview

2094956 - ODBC: SQLDescribeParam throws errors such as The untyped variable ? is allowed only in in a WHERE clause or the SET clause of an UPDATE statement or the VALUES list of an INSERT statement or The data type or the function is not supported - SDK for SAP ASE

Symptom

  • Some queries (INSERT in this case) are sent to ASE as dynamic SQL and return an error:
    • [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The untyped variable ? is allowed only in in a WHERE clause or the SET clause of an UPDATE statement or the VALUES list of an INSERT statement (7332)
    • [SAP][ASE ODBC Driver]The data type or the function is not supported. (30094)
  • The insert command is in the form of INSERT into TABLE (Column List) SELECT convert(type, ?), ....
  • The ODBC application calls SQLDescribeParam, and forces ASE ODBC to issue dynamic SQL to obtain the metadata on the parameters and ASE doesn't support this syntax for dynamic SQL and throws the errors.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7 SP122
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • Adaptive Server Enterprise ODBC Driver by Sybase

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; SAP PowerBuilder 12.5 ; SAP PowerBuilder 12.6 ; Sybase Software Developer Kit 15.7

Keywords

Adaptive Server Enterprise   , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.