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
2 answers
Netezza format in SAS
I have an error when I run SAS format at Netezza. I added the format at the beginning of the following code. However, it didn't work those at Netezza. If possible, could you help to see the two put statement in where statement at PROC SQL part?…
user1238178
- 135
- 3
- 10
0
votes
1 answer
correlated Queries in Netezza
How will I re-write co-related query in Netezza database when I have a query like below in oracle database...
select table1.column1,
case when table2.column2='xxxx' then
( select max(table3.column3)
from table3
…
user2740397
- 31
- 1
- 1
- 4
0
votes
2 answers
how to get rid of decimal points in netezza
Hi I have a weird requirement
if an amount value is 0.00 i need to display it as 0
and if its something else like
23.12 I need to have the decimal points and display as 23.12...
tried below code in netezza but doesn't work
select
case when…
user2740397
- 31
- 1
- 1
- 4
0
votes
2 answers
IBM Netezza, How to convert a varchar to a numeric with TO_NUMBER(..., ...)
I have table called DART_STG1 in Netezza Database. The table has a varchar column. I am trying to use the below SQL to convert the varchar into a number, but it always throws an error.
Code
SELECT DISTINCT TO_NUMBER(M12,'99G99')
FROM DART_STG1…
Teja
- 13,214
- 36
- 93
- 155
0
votes
1 answer
SSIS and Netezza Fuzzy Looup
I am trying to connect to Netezza using SSIS , connection works fine but when I used Fuzzy look up get the table from Netezza it does not work. How do I know it does not work is because it shows the table but when I go to column mapping I don't see…
user1570210
- 1,169
- 12
- 26
- 37
0
votes
3 answers
SQL random number that doesn't repeat within a group
Suppose I have a table:
HH SLOT RN
--------------
1 1 null
1 2 null
1 3 null
--------------
2 1 null
2 2 null
2 3 null
I want to set RN to be a random number between 1 and 10. It's ok for the number to repeat…
Chris
- 1,421
- 3
- 18
- 31
0
votes
1 answer
Next value function error
I get the following error during postgresql execution:
ERROR [HY000] ERROR: you can only use a 'next value(s)' function within a target list
What is wrong with this sql statement:
SELECT TRFCON.ID
,
case when DDDCON.ID_CON =…
MasterX
- 1
- 2
0
votes
1 answer
Sum of Rows - SQL query
I need to develop a SQL query that does the following:
Column A Column B
Row1 2861682 sum(Row1 to Row5)
Row2 2522226 sum(Row2 to Row5)
Row3 2285983 sum(Row3 to Row5)
Row4 2096046 sum(Row4 to Row5) …
Gallop
- 1,365
- 3
- 16
- 28
0
votes
3 answers
SQL Division - Rows - Netezza
I have data in a netezza database table column as follows:
Slno Ads
1 282542
2 2492266
3 2259286
4 2072619
5 1915098
6 11567811
7 10097
8 5900
9 …
Gallop
- 1,365
- 3
- 16
- 28
0
votes
2 answers
How to get common IDs in each group from a group by SQL clause?
I have data of calls for customers. I want to get those customers between two dates that have activity against every date. They did at least one activity every day. I tried following query.
Following is the query:
select date_id , count (distinct…
Tahir
- 3,344
- 14
- 51
- 69
0
votes
0 answers
Call to undefined function odbc_connect()
This is my first time using the php function odbc_connect(), I mostly work with php/mysql. The issue I am having is the function does not work. I have been reading up on the issue and the only resolution I can come up with is that either through…
powpow12
- 587
- 8
- 13
0
votes
1 answer
Group aggregation and descriptive columns
A group is defined by column a, b and c. Column x, y and z from each group are the same. Sample:
a|b|c|x|y|z| ....
1 1 1 p r s
1 1 1 p r s
1 1 1 p r s
2 1 2 t u v
2 1 2 t u v
I am looking to achieve the following however without using aggregate…
martez
- 107
- 1
- 11
0
votes
2 answers
What is the difference between table and external table in Netezza?
What is the difference between table and external table in Netezza? Does it always reads datafile in the backend after loading data is it required to again copy data from external table to normal database table?
Dhams
- 251
- 7
- 15
0
votes
1 answer
Netezza Java UDTF custom function
Hi I am new to Netezza and I was asked to develop Custom Java functions and handed the API.
My question is if I can produce the solution with the given requirement. And here is the requirement.
I am given a table, lets name it Table1. I have to…
PK0513
- 57
- 10
0
votes
1 answer
Querying Netezza via SquirrelSQL returns WKT geometry in unknown encoding
I am using SquirrelSQL to write and execute SQL queries on a Netezza database. Using Netezza's spatial capabilities (which are essentially the same as those of PostGIS) I've executed a query and returned a single result that contains a geometry.…
Jack Harrison
- 156
- 8