Questions tagged [netezza]

A data warehouse and analytic appliance suite that IBM purchased around 2010. Utilizes SQL language to query data. It is a contender in the "big data" market and used comparable to Teradata or Hadoop. Pronounced Ne-Tease-Ah.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
315 views

In nzsql, how can I determine the path of the current sql file being executed?

How can I run a script with nzsql that calls other scripts using \i with paths specified relative to the path of the calling script? The solution must work whether nzsql is being run interactively ...
1
vote
0answers
24 views

Netezza Sequence error

I am new to Netezza and have a quick question. I do a simple select of next val from sequence SELECT NEXT VALUE FOR XX.XX.RUN_SEQ FROM _V_DUAL I ERROR [HY000] ERROR: Sequence 46339885 not ...
1
vote
0answers
113 views

Getting Error: invalid UTF-8 sequence - bad continuation byte

I'm inserting into a table from an external csv file and one of the fields in that file has non-ascii characters. An example of the character is this: É. Here is my insert statement: INSERT INTO ...
1
vote
0answers
697 views

What would be the rule for parsing parameterized sql for Netezza to be used with nzsql?

I have a bunch of legacy parametrized SQL templates that were used by nzsql utility for Netezza. See examples here: http://queforum.com/netezza/347918-parameterized-sql-file-input-nzsql.html What is ...
0
votes
1answer
25 views

Select based on list of pairs

I have a table with two main columns, id1 and id2: drop table if exists pairs; create table pairs (id1 int, id2 int); insert into pairs values (1,2), (1,3), (3,1), (2,4), (5,4), (3,6), (7,8); I ...
0
votes
1answer
2k views

How to find view dependencies in Netezza?

I want to find the dependent table of views in Netezza. Is there a table that provides the details?
0
votes
0answers
428 views

OLE DB provider “MSDASQL” for linked server returned message “ERROR: reserve exceeded : Out of memory ”

We have SQL Server 2012 database which pulls data using a linked server to a Netezza database. We have had a memory issue reported in an overnight batch. Error message: OLE DB provider "MSDASQL" for ...