SAP Knowledge Base Article - Preview

2186641 - Derived table '%1' has no name for column %2 - SAP IQ


When executing SELECT query with derived table, the following error is returned.

select test_tb.c1 from
(select c1, c2, c3, dateformat(now(),'YYYYMMDDHHNNSS')
from gjang) as test_tb
Could not execute statement.
Derived table 'test_tb' has no name for column 4
SQLCODE=-163, ODBC 3 State="42000"
Line 2, column 1



  • SAP IQ 16.x
  • SAP Sybase IQ 15.x


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.