Stack Overflow
Stack Overflow

Questions tagged [netezza]

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.

Read more here

1344 questions
-1
votes
2 answers

How to parse out a string in reverse by using sql regular expressions

I need to backtrace a string for a particular value to parse out. Is there any way to get the required output by using regular expressions. ;2N9XsPQQ;PARAMETER_STRING= Required o/p : 2N9XsPQQ Thanks in Advance
Dileep
  • 624
  • 3
  • 10
  • 20
-1
votes
1 answer

Import Unicode text files into netezza table

I have to upload a Unicode text file(want to show Japanese characters etc.) Into a netezza table. I have created a table with nvarchar columns and I have given the below code but it doesn't work. cat *filename.csv|nzconvert -f utf8 -t nfc|tr -d…
laxman
  • 1
-1
votes
1 answer

Netezza- getting count of deleted records from a SQL statement

I am creating a script in Unix where I can put multiple delete NZSQL one after the other. But since the data volume is huge in each table, I want the script to display the output of each delete SQL, like how many records were deleted and how much…
Vivek Rana
  • 43
  • 1
  • 4
-1
votes
1 answer

I have data due by tomorrow and I have to use 12 tables in order to get results

I have used JOIN ON before my WHERE filters and I am having a hard time getting it to run. It is not recognizing the aliases. Should I provide the query in a generic fashion or is this a general enough question without that necessity? EDIT (ADDED…
Agileskunk
  • 1
  • 5
-1
votes
1 answer

Can we use switch case in Netezza sql?

Can we use Switch case statement in Netezza script? If yes, what is the syntax? Is it similar to the switch case syntax in other languages? Thanks, Ammu
Ammu
  • 1
  • 1
-1
votes
2 answers

How to put a timeout on a method C#

Hi all I just had a quick question for you all. For whatever reason, a piece of code periodically does not return and I am not 100% sure yet. To combat this for now, I want to know, using the Close() method below, is there a way to put a timeout on…
user3494110
  • 417
  • 2
  • 9
  • 25
-1
votes
1 answer

find column number in a SQL table in IBM netezza database

I would like to know the column number in a SQL data table in IBM netezza. I do not find it in the following sql query: select * from _v_obj_relation_xdb join _v_sys_object_dslice_info on (objid = tblid) where objname like 'my_table' Any help…
user3601704
  • 753
  • 1
  • 14
  • 46
-1
votes
2 answers

Inserting values in to netezza using a stored procedure

I'm working with netezza database and have a requirement to insert a Y flag for stores in California. I wrote the below procedure CREATE OR REPLACE PROCEDURE MY_NEW_PROCEDURE() RETURNS BOOL EXECUTE AS OWNER LANGUAGE NZPLSQL AS BEGIN_PROC DECLARE …
karthikc
  • 1
  • 1
  • 1
-1
votes
1 answer

Netezza Error[HY000]

I'm working on Netezza platform and i'm totally new.I have a query as shown below SELECT * FROM HIST_admin."$v_hist_successful_queries" WHERE QUERY LIKE '%WI0PIR_PACKITEM_BREAKOUT_NBS%' AND submittime > now() - interval '6 month' GROUP BY…
Kishor m n
  • 45
  • 1
  • 7
-1
votes
2 answers

Select Sql with space in data

I have a table where the data looks like below: col1| col2 | col3 101 | AA AB | AAAA 102 | ACA B | AAAA 103 | ACBA | AAAA 104 | ABCD | AAAA What I am trying and need is, select all the records that have a space in col2, from the above example,…
user3040077
  • 71
  • 2
  • 10
-1
votes
1 answer

Retrieve all distinct records from table and if any changes happen between two similar distinct record then need to consider both. Using select query

I want to convert table1 into table2. As I need to find out all distinct records excluding mis_date fro the table and most important condition is if any changes happen between two similar distinct records than in that case I want both of them as…
zaman
  • 3
  • 1
-1
votes
2 answers

Need to delete duplicate records from a table with 30 columns

I need to delete the exact duplicate records from a table with 30 columns. My data would look something as attached.Advance Thanks!!
Dileep
  • 624
  • 3
  • 10
  • 20
-1
votes
3 answers

Concatenate columns in vertica doesn't work

I am trying to get an insert statement export from a vertica database table. I am trying to create a query that generates insert statements but I am experiencing syntax issues. How can I do something like the below in Vertica? select "insert into…
Doublespeed
  • 1,153
  • 4
  • 16
  • 29
-1
votes
2 answers

Find Dates - SQL

I have the following from and to dates and need to list using a dynamic sql query only the 3 dates that are mentioned below in netezza database From To 20120603 20120831 Required Result: 20120702 20120703 20120801 Is there a…
Gallop
  • 1,365
  • 3
  • 16
  • 28
-2
votes
1 answer

Trying to use join to aggregate data and getting odd output

When running this query been getting an odd error I've not yet encountered, this query is executed within Netezza SELECT a.CALENDAR_DATE, b.NewBusinessUnit, b.ResellerID, b.ResellerName, a.PRODUCT, a.CLI FROM …
WildJester
  • 1
  • 3
1 2 3
…
89
90