From thibaut.pillas at fr.thalesgroup.com  Fri Aug 13 15:41:46 2004
From: thibaut.pillas at fr.thalesgroup.com (thibaut.pillas@fr.thalesgroup.com)
Date: Fri Aug 13 15:41:50 2004
Subject: [Rd] RODBC problem (or bug?) (PR#7167)
Message-ID: <20040813134146.524CE111ED@slim.kubism.ku.dk>

 
 
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]]


[Rd] RODBC problem (or bug?) (PR#7167)
thibaut.pillas@fr.thalesgroup.com