Skip navigation

Manage categories

Close

Create and manage categories in Users. Removing a category will not remove content.

Categories in Users
Add a new category (0 remaining)

Manage Announcements

Close

Create and manage announcements in Users. Try to limit the announcements to keep them useful.

Announcements in Users
Subject Author Date Actions

Welcome to the Netezza Users Community

This is a customer-to-customer environment where NPS users of all levels of expertise collaborate to inquire, contribute to and gain knowledge about the Netezza Performance Server (NPS). Please use this platform to share any documents or thoughts that you feel will benefit the members of the Customer community.

Recent Activity

Refresh this widget
Gary Glover Gary Glover bookmarked Calling parameterized nz stored procedure from MS Sql Svr Rpting Svcs?

"SSRS/Netezza question"

in Gary Glover's Bookmarks
3 hours ago
Gary Glover Gary Glover asked Calling parameterized nz stored procedure from MS Sql Svr Rpting Svcs?

"I'm a reporting specialist in Data Analytics using primarily SQL Server 2008 R2 with Reporting Services. Our company just purchased a Netez"

in Users 1 bookmarks
3 hours ago
nickg nickg replied to embedded sql using c in netezza

"You can run C code on an external CPU and execute SQL on Netezza via ODBC or JDBC.   You can code UDF's in C# and other languages and compi"

in Users 1 replies
4 hours ago
Priyaranjan Singh Priyaranjan Singh asked embedded sql using c in netezza

"Hello everybody,   In my project we are migrating data fron DB2 to netezza. we need to convert all the existing c scripts (using embedded S"

in Users 0 bookmarks
16 hours ago
Jordan Chernev Jordan Chernev replied to NzAdmin port

"This looks like more of a sysadmin question than a Netezza question. You have a few options.   You can either setup a SSH tunnel (which is"

in Users 3 replies
20 hours ago
tamucgradstudent tamucgradstudent replied to Issue while loading a column with dateformat "MON DD YYYY HH12:MI:SS:FFFAM" using NZLoad?

"Nick, Thanks for the reply."

in Users 2 replies
1 day ago
nickg nickg replied to Issue while loading a column with dateformat "MON DD YYYY HH12:MI:SS:FFFAM" using NZLoad?

"Netezza expects a decimal point for the fractional portion of seconds.  You must change the format in the file before you can load it using"

in Users 2 replies
1 day ago
tamucgradstudent tamucgradstudent started the discussion Issue while loading a column with dateformat "MON DD YYYY HH12:MI:SS:FFFAM" using NZLoad?

"Hi,   I am trying to load a flat file with "Feb 20 2012 12:00:00:000AM" as the date format using nzload from the command prompt.   Follo"

in Users 0 bookmarks
1 day ago
Li Sun Li Sun asked show Netezza tables in R

"When a channel to netezza is created using odbcConnect, sqlTables(channel) displays all table names of the database. However, if I use nzCon"

in Users 0 bookmarks
1 day ago
frankjustme frankjustme bookmarked SQLULDR2 text unload utility
in frankjustme's Bookmarks
6 days ago
Shawn Fox Shawn Fox replied to Formatting a $ value

"SELECT translate(TO_CHAR( 123456.78, '$999,999,999.99'), ' ', '');   the only problem with using translate is that it is not going to resul"

in Users 1 replies
1 week ago
Rajesh Rajesh asked Formatting a $ value

"Guys,   I was trying to format $ value  say 123456.78 using the following command. SELECT TO_CHAR( 123456.78, '$999,999,999.99')   And I"

in Users 0 bookmarks
1 week ago
Saket Kale Saket Kale replied to nzload and maxerrors option

"Yes, I too have been using nzload with the -maxErrors option set to 0 and there is a considerable loss of data since it becomes resilient to"

in Users 6 replies
1 week ago
ganesh.soundar ganesh.soundar replied to Delimiter for space and fixed width in nzload?

"What do you mean by delimiter for space and fixed width files? There is no column delimiter for fixed width files. You should create a contr"

in Users 2 replies
1 week ago
Shawn Fox Shawn Fox replied to Delimiter for space and fixed width in nzload?

"A fixed width file doesn't have delimiters, that is the entire point of fixed width.  I'm not sure what you mean when you say space, do you"

in Users 2 replies
1 week ago

Popular Documents

Subject Author
IsNumber Function Equivalent 3 years ago by rrshep rrshep