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

From: <thibaut.pillas_at_fr.thalesgroup.com>
Date: Fri 13 Aug 2004 - 23:41:46 EST

   

Hello,  

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  
status                  
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
SQLExecute"

[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 normal?
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]]



R-devel@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Fri Aug 13 23:44:20 2004

This archive was generated by hypermail 2.1.8 : Wed 03 Nov 2004 - 22:45:07 EST