2492193 - "Variable not found" error when running a "Select ... Into..." statement.

Symptom

When running a SELECT...INTO statement to create an IQ base table, an error below happened.

(DBA)> SELECT YEAR INTO Y FROM DBA.YEAR
Could not execute statement.
Variable 'Y' not found
SQLCODE=-260, ODBC 3 State="42000"
Line 1, column 1
SELECT YEAR INTO Y FROM DBA.YEAR
Press ENTER to continue...

Environment

SAP IQ16 SP11

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

SAP IQ, IQ, variable not found, SQLCODE=-260, Select, variable , KBA , BC-SYB-IQ , Sybase IQ , 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.