[R-sig-DB] append rows to Sybase datatable using RJDBC function dbWriteTable

[Li, Jing Yi]

> Hi,
> 
> Does anyone have experience using RJDBC library to write to Sybase
> datatable? The jdbc driver I am using is jConnect 6.0. I can
> successfully write into a new datatable, but have problem appending
> rows to existing one. It either complains "Table *** already exists"
> or simply overwrite the existing one. Here is the example.
> 
> I am trying to append "data" to the existing datatable "tmp"
> 
> > data
>   	SecurityID 	Ticker
> 1     	12345  		AAPL 
> 
> > dbWriteTable(conn, "tmp", data, append = T, overwrite = F)
> Error in .local(conn, name, value, ...) : 
>   Table `tmp' already exists
> 
> > dbWriteTable(conn, "tmp", data, append = T)
> [1] TRUE 
> 
> The first dbWriteTable failed as it's complaining "tmp" already
> exists, it looks strange to me as append is set to TRUE. The second
> dbWriteTable succeeded but it actually overwrite exisiting rows with
> "data" which is not expected as append is set to TRUE and overwrite is
> default to FALSE. 
> 
> Can anyone shed me some lights here? Thanks a lot for your help! 
> 
> Jingyi
> 
> 
> 
> 

=============================================================================== 
Please access the attached hyperlink for an important el...{{dropped:8}}