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 = '****' and COL004 = '****' and COL006 in( '3','4' )
group by COL003,COL004,COL005,COL006) as B
on A.COL008 = B.COL005 and A.COL009 = '****'
where A.COL003 = '****'
and A.COL009 = '*****'
and A.COL010 = '**'
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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.