search for: destchannel

...er, using sqlCopy in the RODBC package. RemoteChannel = connection to remote database LocalChannel = connection to local database LocalTable = table in my local database to receive data from the remote database query <- select query in SQL sqlCopy(RemoteChannel, query, "LocalTable", destchannel=LocalChannel, safer=TRUE) I am currently getting an error: Error in sqlSave(destchannel, dataset, destination, verbose = verbose, : table 'LocalTable' already exists I need to append the data retreieved through the query, to the table LocalTable. It was my understanding that when safe...

...ying channel 'instances', which are what Asterisk creates when it creates a channel struct internally. The uniqueID field on the CHANNEL struct uniquely identifies that channel instance across time for a single server. (Currently). (barring masquerades). These are what are REFERENCED by my destchannel, and channel fields. I provide new fields called "channel_uniqueid" and "dstchannel_uniqueid" to reference these fields; not just the channel name (dahdi/1-1 doesn't quite suffice across time.) (But I left the old fields alone for those who prefer device info). CDR unique ID...

Can anyone give advice how to interactively exchange data between R and SQL-Databases like DB2, ORACLE, MS-SQL-Server ? If the answer is: 'currently not', this would be information for me as well. I will summarize to the list. Best regards -- Dr. Jens Oehlschl?gel-Akiyoshi MD FACTORY GmbH Bayerstrasse 21 80335 M?nchen Tel.: 089 545 28-27 Fax.: 089 545 28-10 http://www.mdfactory.de