[R] Using R with Netezza

[Uwe Ligges]

Please ask your Netezza support. I now they are proud on their R support 
and will certainly help.

Uwe Ligges


On 16.02.2012 00:36, rusernetezza wrote:
> We've recently installed a Netezza server and I am trying to integrate the R
> GUI with this server and run functions using the server itself.  I am able
> to successfully connect to the server, but cannot get any of the
> Netezza-specific R functions to work that exist in the package called "nza".
>
> Specifically I am trying to start with a simple function from this package,
> for example "nz.corr".
>
> I am typing the syntax as given in the manual as follows:
> nz.corr(intable="mytable", X="x", Y="y", outtable="anothertable")
> Here is my syntax:
> nz.corr(intable="JMF_TEST_LOOP2",x="PAGE_REFRESH_ID",
> y="PAGE_REFRESH_ID2",outtable="JMF_TEST_LOOP3")
>
> but I receive the following error:
>
> Error in nz.corr(intable = "JMF_TEST_LOOP2", x = "PAGE_REFRESH_ID", y =
> "PAGE_REFRESH_ID2",  :
>    unused argument(s) (x = "PAGE_REFRESH_ID", y = "PAGE_REFRESH_ID2")
>
> I've tried many combinations of syntax using lowercase/uppercase,
> single/double quotes, with and without the x=, y= references, etc., but I
> still get the same error.
>
> Has anyone worked with this "nza" package and have any advice on the syntax?
>
> One other question I have that may or may not be related is - is the
> "outtable" something that can exist in Netezza or does it have to exist in
> R?  Also, I'm assuming the "outtable" is a table that has not already been
> created - is that a correct assumption?
>
> Thanks for any help you can give.
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Using-R-with-Netezza-tp4392417p4392417.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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.