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
0
votes
1 answer

column to row conversion of data in netezza

I have data into below format in source table : MTH_ID VOL 201306 29699420633 201307 31573662296 201308 31482365216 201309 31037480379 201310 33828084122 I want to write a sql query in netezza to convert data into…
Sandy_Unknown
  • 41
  • 4
0
votes
1 answer

How to compare data in Netezza using DataStage

Can I compare these two rows using DataStage then update if the Status field changing? ID | desc | ... | ... | Status | Start_Date | End_Date ------------------------------------------------------------ 123456 | ... | ... | ... | Y |…
colintobing
  • 167
  • 2
  • 14
0
votes
1 answer

Date comparison in Netezza does not work properly

I am trying to run a simple query that excludes all records from the table which are greater than the maximum value of a date column. e.g. SELECT * FROM TABLE1 WHERE LD_TMSTMP > (SELECT MAX(LD_TMSTMP) FROM…
jawsnnn
  • 91
  • 2
  • 11
0
votes
1 answer

C# SQL insert into Netezza. Netezza not sending return, c# code timing out

I'd really like some advice on this as I have been running into this issue quite a bit now. I have a couple applications, both big and small where I need to do some work with Netezza. Unfortunately, it seems a common issue with .net and Netezza, is…
user3494110
  • 417
  • 2
  • 9
  • 25
0
votes
0 answers

How to setup Netezza connection using gradle build file?

I want to setup a netezza connection using gradle. I have added this: compile group: 'net.sf.squirrel-sql.plugins', name: 'netezza' , version: '3.5.0' And the application properties file looks as follows: # Connection Details for Netezza. Below…
lalet scaria
  • 87
  • 2
  • 9
0
votes
2 answers

Converting Netezza timestamp to Julian Day Number

I have been looking for it during days but could not find how to do.. It is like: select to_number(to_char('2015-06-24 00:00:00','J')) on Oracle. I need to find the Julian Numeric Day value, not to be confused with the ordinal date of the year..
Yusuf Göker
  • 3
  • 2
0
votes
0 answers

XML Parsing in Netezza Failing

* declare @XML XML=' - - -
Manoj Soundararajan
  • 371
  • 1
  • 3
  • 13
0
votes
1 answer

netezza left outer join query performance

I have a question related to Netezza query performance .I have 2 tables Table A and Table B and Table B is the sub set of Table A with data alteration .I need to update those new values to table A from table B We can have 2 approaches here 1) Left…
Anoop R
  • 545
  • 3
  • 8
  • 19
0
votes
1 answer

I can't connect Netezza with microsoft ODBC (VS 2013)

I install netezza ODBC drivers and configure data sources(ODBC) in Adminitstrative tools by add user DSN as NZSQL. Next I connect with Visual studio 2013 using DSN in Server Explorer, in Datasource I select Microsoft ODBC data source and data…
Mr. Sittipat Chamnongsilp
  • 21
  • 3
0
votes
1 answer

Connectionstring of netezza with .net framework VS 2013

I saw the connectionstring of netezza ODBC with .NET framework and its make me confude example: Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue; Please help me explain what's any odbc driver's name what's somevalue in OdbcKey1…
Mr. Sittipat Chamnongsilp
  • 21
  • 3
0
votes
1 answer

Netezza TO_CHAR Function not evaluating appropriately?

I am having issues with a query that, if ran with hard-coded dates, will insert the correct number of rows into a table (170K+). The issue is, when I try to automate it, by replacing the hard-coded dates with date functions, the query will then only…
justin mcnamara
  • 3
  • 4
0
votes
3 answers

Greatest/least or max/min calculation in SQL

I want to calculate max(min(150,value returned by below query),50). How do I implement this in netezza? I need to pass the value returned by the below query into the above statement and compute the value of the expression.Appreciate your time and…
sql_learner
  • 49
  • 1
  • 5
0
votes
1 answer

Netezza get records last updated in last 5 minutes using a last modified time stamp column in the table?

How to select records that updated in last 5 minutes using a last_modified_timestamp column in the table using current_date or current_timestamp function in Netezza?
RAJESH
  • 404
  • 6
  • 18
0
votes
1 answer

Differentiate transactions by customer, given sales table (customer_id, article_id)

This is hard to explain but I'll try my best. There is a sales table, that has a row for every article that a customer buy (simplified). so, for example, if a customer go to the store and buy 3 things, and then another customer buy 2 things, the…
Marcelo
  • 429
  • 1
  • 6
  • 19
0
votes
2 answers

Dbfit for Netezza not working

Hi I am new to dbFit and while trying to use dbFit for Netezza giving error Cannot load Netezza database driver org.netezza.Driver. Code and error details are as below: Code: !path lib/*.jar !| dbfit.NetezzaTest | !| Connect | ip | user| password…
Dham
  • 11
  • 4
1 2 3
…
89 90