Skip navigation
Login or Register to find out more about shawnkfox
Shawn Fox has no profile image available
Name:
Shawn Fox
Status Level:
Enzee Exraordinaire Enzee Exraordinaire (2,242 points)
Member Since:
Aug 15, 2006
Company:
Netezza
Company Homepage:
http://www.netezza.com
City:
Dallas
State:
TX
Relationship with Netezza:
Netezza Employee
Groups:
TwinFin Talk   Enzee Universe   Competitive Product Chat   Retail/CPG Focus   Data Liberation Movement

Recent Activity

Shawn Fox replied to NzAdmin port

"nzadmin uses ports 5480 and 5481.  The 5480 port is also used by jdbc and odbc."

in Users 2 replies
2 days ago
Shawn Fox replied to create domain/datatype in Netezza  ( user defined datatypes )

"Netezza does not support user defined datatypes."

in TwinFin Talk 1 replies
2 days ago
Shawn Fox replied to How to add optional quote option in nzload script?

"From "nzload -h"   -quotedValue <type>      fields are unquoted (NO) / enclosed in optional [SINGLE|DOUBLE] quotes: NO / YES, SINGLE, DOUBL"

in Users 1 replies
3 days ago
Shawn Fox replied to Installing Python Libraries on SPUs

"Greg,   I'd recommend that you look at the NZAE_ROW_BUFFER environment variable.  This can greatly improve performance of table functions u"

in TwinFin Talk 3 replies
4 days ago
Shawn Fox replied to Read a file using external table without using the structure(the columns)

"Bhuvaneswaran K wrote:   But how to read as a single character column?   You can't actually read just 1 character per line out of the file"

in Enzee Universe 5 replies
4 days ago
Shawn Fox replied to JDBC driver 4.6.6 returning exception instead of null to driver manager

"Brian,   This is a known issue, it has been fixed in the 6.0.2 (and higher) JDBC drivers.  The most recent release is 6.0.5 P4."

in Users 2 replies
4 days ago
Shawn Fox replied to Option to increase line size

"I'm not really clear on what your problem is here.  Did you define the external table to have a column larger than varchar(2000)?  Is the ta"

in TwinFin Talk 2 replies
4 days ago
Shawn Fox replied to Installing Python Libraries on SPUs

"The /nz/export directory is NFS mounted to all of the SPUs, so if you create a directory called /nz/export/local/python and copy your python"

in TwinFin Talk 3 replies
5 days ago
Shawn Fox replied to Replication to Netezza

"From what I understand IBM Replication Server added Netezza as a target a few months ago so you should take a look at it as well.  I don't k"

in Enzee Universe 4 replies
1 week ago
Shawn Fox replied to install nzlua script

"By default nzLua uses the NZ_DATABASE environment variable to determine where a UDX will be installed.  You can also use the -d option on th"

in TwinFin Talk 1 replies
1 week ago
Shawn Fox replied to Can nzsql read host from an environment variable?

"These environment variables are all supported, usage should be pretty obvious.   NZ_DATABASE NZ_HOST NZ_PASSWORD NZ_USER"

in TwinFin Talk 2 replies
1 week ago
Shawn Fox replied to Current Version of NZ

"Twinfin 12 is the model, 6.0 is the version of the Netezza software running on your Twinfin 12.  I don't think there is a way to know what m"

in Users 4 replies
1 week ago
Shawn Fox replied to Current Version of NZ

"nzrev   or from sql   select version();"

in Users 4 replies
1 week ago
Shawn Fox replied to NZ LUA Function cannot accept Extended HTML character set.

"These are multi byte UTF8 characters:   spade = string.char(0xE2, 0x99, 0xA0) club = string.char(0xE2, 0x99, 0xA3)   Since they are 3 byt"

in TwinFin Talk 3 replies
1 week ago
Shawn Fox replied to Query tuning help

"You have to convert this to an equijoin, one simple way to do this is to create a lookup table that has entries for at least every 4096 IP n"

in Users 1 replies
1 week ago
Shawn Fox replied to NZ operators

"Some of the operators work and some don't.  As Kapil says, you shouldn't use anything which is not documented or hasn't been recommened by s"

in Users 4 replies
1 week ago
Shawn Fox replied to Question on regexp_split_rows UDF

"You can make it varchar(64000) if you like, but that would almost certainly cause problems.  Only make it is as big as it needs to be, other"

in TwinFin Talk 3 replies
1 week ago
Shawn Fox replied to Why doesn't this SP run? Can I not use variables in a loop?

"You just need to add a space before/after the ..   for i in startwk .. endwk loop etc   When using constants you don't need the spaces bu"

in TwinFin Talk 2 replies
1 week ago
Shawn Fox replied to Question on regexp_split_rows UDF

"Just change the code to output columns larger than 255   function getShape()         local shape={}         shape[1] = { "pos", integer    "

in TwinFin Talk 3 replies
1 week ago
Shawn Fox replied to Procedure Question

"So far as I am aware that information is not recorded anywhere.  You would have to first drop the stored procedure then create a new one if"

in Enzee Universe 4 replies
1 week ago

Shawn Fox's Commonly Used Tags

Friends

    Shawn Fox currently has 10 friends.

Shawn Fox's Most Liked Content