I've been having some issues with sqlSave, and I think I've found an clue
that may identify the problem. In the code at http://pastebin.com/W6UGKep9,
I connect to a Netezza instance, make a simple table, and query it.
Despite sqlSave succeeding without error, sqlQuery tells me that the table
doesn't exist. Also, when I query the database outside of R, I see that
the table doesn't exist. However, using sqlFetch works, and (perhaps, as
expected) the table is dropped upon evaluating close(myConn). Also,
sqlDrop works as expected. Thanks for your time. Any thoughts are
appreciated.
Dave Mitchell
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
