R help - Apr 2013 - sqlSave writes, but only for sqlFetch

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/vTAKt4bL<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 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]]

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/0USzNFfq,
I connect to a Netezza instance, make a simple table, and query it.
Despite sqlSave succeeding without error, sqlQuery tells me 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]]