Well I do not know what could be happening.
I tried to append records to a table on DB2 (community Edition 9.5 on
a Linux machine). And it works greatly. The only odd thing (may be
because of my low skills on DB2) is I could not create neither append
to a table on a different schema than dbuser (a
The query generated by R looks ok to me. I went ahead and pasted it into
my DB2 Client command editor. And I got the message confirmation message.
INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", "MACROUSER", "MACRO_RT" )
VALUES ( 's_ej_mach_config_vz', 'jones2', 5 )
DB2I The SQL command com
Now it becomes strange.
One thing I note from this generated query:
INSERT INTO STORAGE.TEST_APPEND2 ( "MACRONAME", "MACROUSER",
"MACRO_RT" ) VALUES ( 's_ej_mach_config_vz', 'jones2', 5 )
The names of the variables are in double quotes; That is a problem.
Can you try to run this query on another
Hi Felipe,
Thanks for your message. Your approach works for an Access database. I am
trying to insert records into a table in a DB2 database on a remote AIX
server.
My userid has the authority to insert records, and I am able to do that
using another application (DB2 Client command line).
Sincerely
Hello Caveman!
I am able to append records using other applications. My credentials have
the authority to append. I am able to query to select records, and even
delete records from the remote DB2 table using RODBC. I'm just stuck when
it comes to APPEND.
The DB2 database is on an AIX server, and
Hello!
Before you try from R. Can you tell us what happens when you use
another DB2 client when you try with those credentials?
One thing to note: If you are trying to access DB2 from ODBC on Linux
on DB2 versions before 9.4 there are some particular issues and better
check this
http://holmwood.
rrillo
Supervisory Fishery Biologist
Department of the Interior
US Fish & Wildlife Service
California, USA
--- On Fri, 10/16/09, Elaine Jones wrote:
> From: Elaine Jones
> Subject: [R] RODBC sqlSave does not append the records to a DB2 table
> To: r-help@r-project.org
>
I am running R version 2.9.2 on Windows XP OS with RODBC version Version:
1.3-0.
Has anyone out there in the R user community successfully appended records
to a DB2 table on a remote database using the sqlSave function in the RODBC
package? (or by any other means from R?)
I posed a similar que
8 matches
Mail list logo
