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 TSMABDB06 as A  
 set siljeokgeumaek5 = B.siljeokgeumaek5,   siseutemchoejongcheoriilsi = cast(REPLACE(DATEFORMAT(NOW(),'yyyymmddhhnnss.ssssss'),'.','') as char(20))
 from   TSMABDB06 as A  
  join( select gijunnyeonwolil,     KPIkodeu,     gwanribujeomkodeu,     cast(sangpumgubun as decimal(5)) as 화면표시순서,     SUM(pyeonggageumaek) as siljeokgeumaek5    
   from TTMABDP51    
   where gijunnyeonwolil = '20160100'     and KPIkodeu = 'D3040'     and sangpumgubun in( '3','4' )     
   group by gijunnyeonwolil,KPIkodeu,gwanribujeomkodeu,sangpumgubun) as B  
  on A.bujeomkodeu = B.gwanribujeomkodeu   and A.bogoseokodeu = 'D3040'  
 where A.gijunnyeonwolil = '20160100'  
 and A.bogoseokodeu = 'D3040'  
 and A.bogoseogubun = '00'  
 and A.bujeomkodeu = B.gwanribujeomkodeu  
 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 TSMABDB06 as A   set siljeokgeumaek5 = B.siljeokgeumaek5,............................  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.
     
      /home1/jerry/work>dbisqlc -c dsn=dba -q error.sql
 Error in file kb.sql at line 0
 Column '화면표시순? not found
 
 /home1/jerry/work>dbisql -c dsn=dba -nogui error.sql
 0 row(s) updated
 Execution time: 0.162 seconds
 /home1/jerry/work> 


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.