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

2010-10-08 Thread Li, Jing Yi
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 o

[R] append rows to Sybase datatable using RJDBC

2010-10-12 Thread 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 exist

Re: [R] append rows to Sybase datatable using RJDBC

2010-10-12 Thread Li, Jing Yi
yes. c(T,F) does return [1] TRUE FALSE -Original Message- From: David Winsemius [mailto:dwinsem...@comcast.net] Sent: Tuesday, October 12, 2010 10:00 AM To: Li, Jing Yi Cc: r-help@r-project.org Subject: Re: [R] append rows to Sybase datatable using RJDBC On Oct 12, 2010, at 9:51 AM

[R] previous business day

2010-10-21 Thread Li, Jing Yi
How to get the previous business day in R? I saw some post about using functions in timeSeries package before but can not find it anymore. Thanks! === Please access the attached hyperlink for an important el...{{dropped

Re: [R] previous business day

2010-10-21 Thread Li, Jing Yi
: Thursday, October 21, 2010 4:16 PM To: Henrique Dallazuanna Cc: Li, Jing Yi; r-help@r-project.org Subject: Re: [R] previous business day May also wish to "or" in a check for holidays. -- Clint BowmanINTERNET: cl...@ecy.wa.gov Air Quality Modeler

Re: [R] previous business day

2010-10-21 Thread Li, Jing Yi
, 2010 4:34 PM To: Li, Jing Yi Cc: Clint Bowman; Henrique Dallazuanna; r-help@r-project.org Subject: Re: [R] previous business day On Oct 21, 2010, at 4:20 PM, Li, Jing Yi wrote: > Yeah, thanks Henrique for the code. It works! But I also have the > questions for the holidays. > >

Re: [R] previous business day

2010-10-22 Thread Li, Jing Yi
yes. do you know the name of related functions in the timeDate package? Thanks! -Original Message- From: David Reiner [mailto:david.rei...@xrtrading.com] Sent: Friday, October 22, 2010 10:10 AM To: Li, Jing Yi; David Winsemius Cc: r-help@r-project.org Subject: RE: [R] previous business

Re: [R] previous business day

2010-10-22 Thread Li, Jing Yi
Great. Thanks a lot! Please follow the attached hyperlink to an important disclosure: http://www.credit-suisse.com/legal/marketcommentary -Original Message- From: David Reiner [mailto:david.rei...@xrtrading.com] Sent: Friday, October 22, 2010 11:59 AM To: Li, Jing Yi Cc: r-help@r

Re: [R] previous business day

2010-10-22 Thread Li, Jing Yi
Thanks for the info! -Original Message- From: David Scott [mailto:d.sc...@auckland.ac.nz] Sent: Friday, October 22, 2010 4:19 PM To: David Reiner Cc: Li, Jing Yi; r-help@r-project.org Subject: Re: [R] previous business day On 23/10/2010 4:59 a.m., David Reiner wrote: > Look at