nickg

"A string is limited to 64000 bytes (either 64000 ASCII characters or 16000 UNICODE characters).  I believe there is also a total row width l"

"Have you generated statistics on the tables?"

"select statement from table B full outer join table B (self join comparing two enterits) -> of which output should go in .dat file.   Isn't"

"No.  NZSQL is implemented on the hardware.  There use to be a Netezza simulator (essentially an NZSQL emulator) that ran under Windows, but"

"Manually?  Don't think so.   Anyway, Kimball suggests exploding the heirarchy, creating a bridge table that contains any parent and all its"

"If you are doing inserts only into the table, and the date pretty much represents the chronological order the rows are insterted, the zone m"

"It is possible to define a UDF such that it executes on the host, but it's use single threads the execution of the query.  The Netezza box w"

"This form of SELECT executes on the host (it is essentially an assignment statement):   SELECT read_file(TO_DATE('2012-05-09', 'YYYY-MM-DD')"