[Rd] RODBC problem (or bug?) (PR#7167)

thibaut.pillas at fr.thalesgroup.com thibaut.pillas at fr.thalesgroup.com
Fri Aug 13 15:41:46 CEST 2004

I have a problem with the package RODBC (version 1.0-4). I am using DB2.
Here is the situation:
> version
platform i386-pc-mingw32
arch     i386           
os       mingw32        
system   i386, mingw32  
major    1              
minor    9.0            
year     2004           
month    04             
day      12             
language R              
odbc connection is OK
Core is the schema of the table "chunk" for DB2
*        Sqlquery select name_variable from core.chunk,...  --> no problem,
R recognize core.chunk 
*        sqlFetch(channel, "CORE.CHUNK") --> Error in
odbcTableExists(channel, sqtable) : 
        CORE.CHUNK : table not found on channel
*        Sqlfetch(channel, "chunk") --> [1] "[RODBC] ERROR: Could not

[2] "S0002 -204 [IBM][CLI Driver][DB2/NT] SQL0204N The name
\"KWADMIN.CHUNK\" is not defined.  SQLSTATE=42704\r\n"
It's not kwadmin.chunk but core.chunk (kwadmin is the userId)
Why does it search kwadmin.chunk?
The table's name for sqlquery is core.chunk and for sqlfetch is chunk. Is it
Is there any solution with R or is it a problem with DB2?
Thank you very much for your answer
Yours sincerely
Thibaut Pillas

	[[alternative HTML version deleted]]

More information about the R-devel mailing list