R help - Feb 2012 - Using R with Netezza

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.

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.