Netezza is a line of high-performance data warehouse appliances and advanced in-database analytics applications for uses including enterprise data warehousing, business intelligence, and predictive analytics. In 2010, Netezza became a subsidiary of IBM, and the product was subsequently rebranded as "PDA” In 2019 IBM launched a new generation of Netezza/PDA on the CloudPack for data stack. It runs on both cloud and on-prem specialized CP4D hardware.
Questions tagged [netezza]
1344 questions
0
votes
1 answer
CASE statement equivalent to if or else-if
In this sql CASE statement:
CASE WHEN col1 = 'X' then 'A'
CASE when col2 = 'Y' then 'B'
else 'C' as result ...
if col1=X, and col2 = Y, will the output be 'A' or 'B' ? i.e. is the CASE statement functioning as an if or an else-if?
Victor
- 16,609
- 71
- 229
- 409
0
votes
2 answers
how do I convert mmyy to last day of month in netezza
One of my column needs to be transformed into a date field. It contains a value that gives the YYMM and it should be translated into the last day of that month:
For example, 1312 should become 12/31/2013.
I have tried various last_day, to_char…
0
votes
1 answer
can we implement autonomous transaction in Netezza Stored procedure
Netezza has a single commit else rollback in the SP. So if a Netezza SP fails, the control goes to Exception block, in that case does anyone know if I put a insert into error table or call another SP, will that transaction in exception gets…
user3406675
- 148
- 9
0
votes
3 answers
Error when updating table from another table
My statement look like this,
update DATA_SOURCE tgt
set
tgt.DATA_SOURCE_NM=src.DATA_SOURCE_NM,
tgt.ODS_UPDATE_TS=src.ODS_UPDATE_TS
select DATA_SOURCE_NM,ODS_UPDATE_TS
from DATA_SOURCE_BKP src
where tgt.DATA_SRC_ID=src.DATA_SRC_ID;
I got…
Dinesh Subedi
- 2,603
- 1
- 26
- 36
0
votes
1 answer
Loading a data file in Netezza Emulator
I am trying to load some data in a remote Netezza Server through VMWare Virtual Machine. The command I used is
nzload -u admin -pw password -db system -t testtable -delim ',' -df 'C:\test\testtable.csv'
But I am receiving an error - dataobject…
0
votes
2 answers
IBM Netezza and node.js
Anyone knows if there is a driver for the IBM Netezza database for node.js? Google search yielded nothing.
Also how is the support for other RDBM in node.js?
Hoffmann
- 14,369
- 16
- 76
- 91
0
votes
1 answer
Does oracle /netezza execute subqueries only once
In this query:
select L1.*, L2.* from (select t1.col1, max(t1.col2) from ($subquery) t1, group by t1.col1) L1, ($subquery) L2 where L1.col1 = L2.col1
Will Oracle/Netezza execute the $subquery only once? Or twice?
Victor
- 16,609
- 71
- 229
- 409
0
votes
1 answer
Dynamically create tables based on comma delimited string in SQL stored proceedure
I am writing a SQL stored procedure that takes in a population name as a parameter, creates a table based on the population name, and then populates the table. It works great as long as I know how many population names I am passing to it ahead of…
dsal1951
- 1,630
- 1
- 16
- 20
0
votes
1 answer
Is there a limit on IN clause for netezza tables?
create table accounts as
select account_name, count(company) from tmp_table
where account_name in (select account_name from test_accounts)
group by account_name;
select * from accounts;
This query only fetches 12 records whereas it should have…
Merrin
- 655
- 2
- 7
- 18
0
votes
1 answer
Netezza Query to the database fails with netezza.max.stmt
I am making a Query to two different databases and there are two different dataSources and the pool is created using c3p0. The queries to the second database fails with the following error
netezza.max.stmt.handles
Could You Please help me with…
Kashyap
- 6,439
- 2
- 22
- 21
0
votes
1 answer
Netezza SP throwing 'unexpected transaction command' Error
I have an SP in Netezza to do UPSERTS between two tables by using a composite key .
It Compiles Correctly but then throws this error :
ERROR: unexpected transaction command in exec_stmt_execsql() - not allowed in stored procedure
DECLARE USERINPUT…
Arpan J
- 11
- 1
0
votes
1 answer
How do i ignore or remove " between words in field
I have a field in a table where the data is one of the following:
ABC" D
"Add"b"
How can I ignore the " character?
I am new to netezza and have some sql knowleged
0
votes
1 answer
Unable to do a executeBatch() on Netezza - JDBC
Im getting an error when i try to do an executeBatch() on netezza. Following is the error:
org.netezza.error.NzSQLException: ERROR: Update canceled: attempt to update a target row with values from multiple join rows..
Please take a look at the…
user988090
0
votes
1 answer
Join multiple tables located in different databases using Informatica
I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is…
Teja
- 13,214
- 36
- 93
- 155
0
votes
1 answer
Can any one explain Netezza Disadvantages?
While i am going through the Netezza OLAP appliance , i could see Netezza dynamic scaling is not possible,
can anyone please explain this ?
William R
- 739
- 2
- 13
- 34