SAP Knowledge Base Article - Preview

2953961 - Received an error: Feature 'lpad' not implemented using LPAD function with DUMMY table - SAP IQ 

Symptom

When we execute a query with LPAD function to follow example in "SAP IQ SQL Reference", the execution fails:

(DBA)> SELECT LPAD ('hello', 15, '12345') "left pad" FROM DUMMY;
left pad
--------

(0 rows)

There was an error reading the results of the SQL statement.
The displayed results may be incorrect or incomplete.
  Feature 'lpad' not implemented
  SQLCODE=-134, ODBC 3 State="HY000"

Line 1, column 1
  SELECT LPAD ('hello', 15, '12345') "left pad" FROM DUMMY

Press ENTER to continue...


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

LPAD, DUMMY, iq_dummy, Feature 'lpad' not implemented , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.