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
-1
votes
2 answers
How to verify SSL Enablement in Netezza Database using a query in client tool like DBVISUALIZER?
I am trying to check or verify SSL is enabled or not for my current Netezza connection.
I have tried multiple queries, but none of the them is working.
Below are some listed queries, which I tried in DBVISUALIZER:-
SELECT * FROM…
sujay777
- 41
- 5
-1
votes
1 answer
sql netezza case when, how to use a temporal variable?
How can i make this kind of CASE WHEN in Netezza:
select
case A+B+C
when 0 then 1
else A+B+C
end
FROM X
the idea is not to write again A+B+C like this
select
case 's' = A+B+C
when 0 then 1
else 's'
end
FROM X
is it possible?
Renzo
- 1
- 1
-1
votes
1 answer
How to remove decimal point and update without decimal for existing records?
I would like to remove the decimal point from the records and update the without decimal point which is already loaded records into the table for 4 fields
datatype: VARCHAR(7)
For example, D21.3 would become D213
Krishna
- 25
- 4
-1
votes
2 answers
Which can be used delimiters in Netezza database
I am trying to insert file into netezza database so I need help which character can we use as delimiters. I was trying these are delimiters.
'|' ',' ';' '~' '^'
But user does not accept it because they are using under sentence.
Abdul Fatah
- 1
- 3
-1
votes
1 answer
Datastage job failed netezza to greenplum data load using ODBC Greenplum Wire Protocol driver
Greenplum_Connector_0,0: The following SQL statement failed: INSERT INTO GPCC_TT_20211121154035261_15420_0_XXXXX_TABLE_NAME (COLUMN1,COLUMN2,...) SELECT COLUMN1,COLUMN2,... FROM GPCC_ET_20211121154035417_15420_0. The statement reported the following…
Lawren Alex
- 110
- 5
-1
votes
2 answers
SHOW CRATE TABLE in Netezza Aginity
What is the equivalent command SHOW CREATE TABLE tbl_name from MySQL in Netezza SQL.
For example I have the iris table with these columns.
My Expected output
Add screenshot using MySQL with HeidiSQL ID
I need a statement equivalent to SHOW CREATE…
Rafael Díaz
- 2,134
- 2
- 16
- 32
-1
votes
2 answers
Calculation of age in Bigquery
Can anyone help me to find the alternative of age function in Bigquery.
Below is some example of AGE function in netezza database.
ex:
SELECT AGE(Current_date,'1994-07-16');
o/p: 27 years 2 mons 21 days
Thanks in advance.
Radha Raman
- 11
- 3
-1
votes
1 answer
Tricky Range lookup in Netezza with duplicate data
Below is the scenario I need solution on this in Netezza SQL.
if you look at below input 2nd record 2nd column is empty but I need value form above 'H' record. expected will be "A,CP,2" for 2nd row. same as for 4th row i would require value from 3rd…
venkatesh
- 1
- 1
-1
votes
2 answers
SYS_CALENDAR function in SQL Netezza
please
how can I run a query that generate a calendar in SQL Netezza like the below query that works with Teradata
SELECT *
FROM SYS_CALENDAR.Calendar
where calendar_date BETWEEN '2021-01-01' and current_date
Ahmed Mohammed Abdel Kader
- 149
- 2
- 12
-1
votes
1 answer
Cursor with sql subquery present as a parameter in BigQuery
I found a previous post (Cursors in BigQuery) where there exists a way to declare cursors on bigquery. This works well and good when the cursor subquery is not present as a parameter.
Currently I was going through FOR..IN EXECUTE construct in…
Abhishek Dasgupta
- 578
- 1
- 8
- 20
-1
votes
1 answer
Age from year and date column Netezza sql
I have data elements like ID; start_date; Birth_year. I want to calculate Age based on the birth_year column and start_date as shown in the AGE column.
I could only think of padding the birth year with '-01-01' and then using that column to…
Prajwal Mani Pradhan
- 381
- 3
- 13
-1
votes
1 answer
Use window aggregation functions with joining SQL Netezza
please the below SQL code, I need to Join TTS table with CMS table where CMS.NEW_COLLECTED_DIGITS = TTS.FULLNUM and I need to join also TTS.LAST_UDATE_DATE with CMS.Call_Date but the challenge is I need to get TTS.LAST_UDATE_DATE between…
Ahmed Mohammed Abdel Kader
- 149
- 2
- 12
-1
votes
1 answer
SQL: How to exclude only the criteria if the 2 criteria are met and not both separately within multiple where?
Select *
FROM SOME_TABLE
where Variable_1 in (1,2,3,4)
and not (Variable_1 in (1) and Variable_2<75000)
So I want Variable 1,2,3,4 included in the output but all variable_1=1 AND <75000 excluded.
I only manage to exclude ALL Variable_1 = 1 and…
John Rut
- 39
- 1
- 1
- 3
-1
votes
1 answer
get the percentage for last 4 months SQL Netezza
I have a simple query with a simple table
SELECT Call_Date, Phone_Num, Call_Type
FROM IVR_TBL
the result like
CALL_DATE |Phone_Num |CALL_TYPE |
---------------------|----------------|----------|
2020-01-30 21:12:0 |0553748547 …
Ahmed Mohammed Abdel Kader
- 149
- 2
- 12
-1
votes
1 answer
How i can migrate this code from netezza to db2?
SET v_ArrayLength= ARRAY_COUNT(ARRAY_SPLIT(p_SeasonsStr, ','));
FOR v_ArrayPos in 1 .. v_ArrayLength LOOP
IF (v_ArrayPos<>v_ArrayLength) THEN
SET v_SeasonsStrs= v_SeasonsStrs||GET_VALUE_VARCHAR(ARRAY_SPLIT(p_SeasonsStr,…
trump4ik
- 1
- 1