SAP Knowledge Base Article - Preview

2094956 - ASE 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

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

  • ASE ODBC Driver 15.7 SP122 and up (also prior)
  • ASE 15.7
  • ODBC application (PowerBuilder can call this SQLDescribeParam API function)
  • Windows

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 ONE Support launchpad (Login required).

Search for additional results

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