SAP Knowledge Base Article - Preview

2284667 - "Column not found" error in dbisqlc - SAP IQ

Symptom

1. When running an specific update statement having double-bytes column name, an error "Column not found" happens.
Not all statements referencing the double-bytes column name run into this error.
 
  [ Update statement ]

update TAB001 as A
set COL001 = B.COL001, COL002 = cast(REPLACE(DATEFORMAT(NOW(),'yyyymmddhhnnss.ssssss'),'.','') as char(20))
from TAB001 as A
join( select COL003, COL004, COL005, cast(COL006 as decimal(5)) as 가가가가가가, SUM(COL007) as COL001
from TAB002
where COL003 = '20160100' and COL004 = 'D3040' and COL006 in( '3','4' )
group by COL003,COL004,COL005,COL006) as B
on A.COL008 = B.COL005 and A.COL009 = 'AAAAA'
where A.COL003 = '20160100'
and A.COL009 = 'AAAAA'
and A.COL010 = '00'
and A.COL008 = B.COL005
and A.가가가가가가 = B.가가가가가가 // <===== Here is the problematic point.

  [ Error ]

Error in file "error.sql" at line 14
Column '가가가가가? not found

2. According to the trace log, the last character of the column name "화면표시순서" was converted into hexa code as below.
     That's why the error happens.


 I. 02/23 12:16:31. <,36,EXEC_IMM,update TAB001 as A set COL001 = B.COL001,............................ and A.가가가가가가 = B.가가가가가\xBC

3. This error happens only when running the statement via dbisqlc, while it's fine with dbisql.

    And, in case of not using the silent mode(-q) when running it through dbisqlc, it also works fine.

$ dbisqlc -c dsn=dba -q error.sql
Error in file kb.sql at line 0
Column '가가가가가? not found

$ dbisql -c dsn=dba -nogui error.sql
0 row(s) updated
Execution time: 0.162 seconds


Read more...

Environment

SAP IQ

Product

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

Keywords

SAP IQ, dbisqlc, column not found, Sybase IQ , 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 ONE Support launchpad (Login required).

Search for additional results

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