Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [netezza]

A data warehouse and analytic appliance suite that IBM purchased around 2010. Utilizes SQL language to query data. It is a contender in the "big data" market and used comparable to Teradata or Hadoop. Pronounced Ne-Tease-Ah.

Filter by
Sorted by
Tagged with
0 votes
1 answer
23 views

Identifying Rows Where Conditions Occur

I am working with Netezza SQL. I have the following table: name year var1 var2 John 2001 a b John 2002 a a John 2003 a b Mary 2001 b a Mary 2002 a b Mary ...
stats_noob's user avatar
0 votes
0 answers
17 views

Which of these SQL Queries is Correct?

I am working with Netezza SQL. I have a table ("my_table") that contains information on: student_id (e.g. 123, 124,etc.) scholarship (1 = yes, 0 = no) : note that a student can receive a ...
stats_noob's user avatar
0 votes
1 answer
471 views

Generating MD5 Hash for NVARCHAR and VARCHAR columns across different databases

I am building a utility that generates a single MD5 hash across all CONCATENATED column values for any table row. To make this work, I have to eliminate NULL values using COALESCE and must CAST NUMBER ...
Lauren_G's user avatar
0 votes
1 answer
287 views

How to generate each query in a separate SQL file using TPC-DS dsqgen tool?

I'm using TPC-DS dsqgen to translate its templates to runnable queries. I tried the following argument variations to save each query in a dedicated .sql file, but they all save the runnable query in ...
Muhammad Gelbana's user avatar
-1 votes
1 answer
454 views

Need SQL query to update the column using case when by joining two tables in Netezza Database

There are 2 tables : Sales & Transaction. I need to update the INDICATOR column of the Sales table using CASE WHEN by joining these two tables in Netezza database. Using below query but not ...
ImSahil's user avatar
1 vote
1 answer
315 views

Netezza migration to Azure Synapse - Stored Procedures?

I have looked everywhere for useful documentation that comprehensively gives me the differences between Netezza stored procedures and functions so I can find Azure Synapse equivalents. Is there any ...
Lauren_G's user avatar
0 votes
1 answer
32 views

Comparing 2 items at different dates

I have a Netezza database which gets a daily feed of account information. I’m trying to write a query which will only return accounts when they experience a price change and advise what the price ...
TriggerG 's user avatar
0 votes
1 answer
1k views

join a lookup table with a data table

I have the following schema in my database Neighbors: ( central_id, neighbor_id) Data: (central_id, value) This schema is for a convolution algorithm which for each central_id I have 6 neighbors(it ...
Majid Hojati's user avatar
1 vote
0 answers
84 views

Netezza Sequence error

I am new to Netezza and have a quick question. I do a simple select of next val from sequence SELECT NEXT VALUE FOR XX.XX.RUN_SEQ FROM _V_DUAL I ERROR [HY000] ERROR: Sequence 46339885 not ...
Dilip Deenadayalan's user avatar
0 votes
1 answer
79 views

Select based on list of pairs

I have a table with two main columns, id1 and id2: drop table if exists pairs; create table pairs (id1 int, id2 int); insert into pairs values (1,2), (1,3), (3,1), (2,4), (5,4), (3,6), (7,8); I ...
Majid Hojati's user avatar
1 vote
0 answers
333 views

Getting Error: invalid UTF-8 sequence - bad continuation byte

I'm inserting into a table from an external csv file and one of the fields in that file has non-ascii characters. An example of the character is this: É. Here is my insert statement: INSERT INTO ...
user162971's user avatar
0 votes
1 answer
3k views

How to find view dependencies in Netezza?

I want to find the dependent table of views in Netezza. Is there a table that provides the details?
Revathy's user avatar
2 votes
0 answers
385 views

In nzsql, how can I determine the path of the current sql file being executed?

How can I run a script with nzsql that calls other scripts using \i with paths specified relative to the path of the calling script? The solution must work whether nzsql is being run interactively ...
menger_sponge's user avatar
1 vote
1 answer
1k views

how to execute unix commands within nzsql?

I'm converting a script from Teradata to Netezza, and I'm stuck at the portion where BTEQ uses the functionality of the OS to check if a file contains any data. If it does, it is deleted. I want to ...
gurvinder's user avatar
2 votes
0 answers
854 views

What would be the rule for parsing parameterized sql for Netezza to be used with nzsql?

I have a bunch of legacy parametrized SQL templates that were used by nzsql utility for Netezza. See examples here: http://queforum.com/netezza/347918-parameterized-sql-file-input-nzsql.html What is ...
Leonid's user avatar
  • 121
0 votes
1 answer
637 views

Windows ODBC Driver versions for Netezza

I am looking for information regarding the Netezza windows ODBC driver versions. What are the supported/preferred windows ODBC driver versions for Netezza 7.2, Netezza 6.1 and Netezza 6.0. Any ...
Arun Bhushan's user avatar
2 votes
2 answers
3k views

How to increase ETL performance in Informatica for Netezza as a source and SQL Server as a target?

What settings or configuration on the Informatica server, in the Informatica software itself, or on the database servers can be changed to increase Informatica ETL throughput? What are some ...
JustBeingHelpful's user avatar
6 votes
4 answers
21k views

Netezza: What schema contains all the system tables / views?

Is there a schema I can look in or a query that I can run to see all the Netezza system or metadata tables? I know about _v_table, _v_view, _v_relation_column, and _v_groupusers. I know there are ...
CraigBoyd's user avatar
1 vote
3 answers
3k views

Last accessed timestamp of a Netezza table?

Does anyone know of a query that gives me details on the last time a Netezza table was accessed for any of the operations (select, insert or update) ? Thanks
user70022's user avatar
0 votes
3 answers
2k views

Executing a script via Powershell possibility

Let's say I don't happen to have the ability to create a Stored Procedure, but I have to run the same query on a regular basis. Would I be able to put my query in a .txt document and be able to run it ...
SQLHound's user avatar
  • 261
0 votes
1 answer
5k views

Query Netezza to find all tables in views

I am trying to recreate the following query in netezza and am struggling: SELECT view_name, Table_Name FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE WHERE View_Name = '<giveViewName>' ORDER BY ...
user66039's user avatar
1 vote
1 answer
1k views

How to generate a random character string of length 8 in Netezza?

I am trying to generate a random character string of length 8 in Netezza, any suggestions?
sumanth's user avatar
  • 11
0 votes
2 answers
6k views

Netezza Error Record size 120000 exceeds internal limit of 65535 bytes

I have a column PARAM that has JSON data that looks like this: JSON:{"Name":"RES_InformationalIssues","StepName":"Page_1","StepData":"f601e9fe-d68a-4ed7-bbaa-f40c9cbc4d12=General Product Information",...
Skylar English's user avatar
0 votes
1 answer
1k views

What does this error mean in IBM Netezza Administrator? - ERROR: Permission denied on "_VT_DISK_PARTITION"

What does this error mean when opening IBM Netezza Administrator? ERROR: Permission denied on "_VT_DISK_PARTITION"
JustBeingHelpful's user avatar
1 vote
1 answer
5k views

how can I call nzsql or nzload from script without disclosing sensitive password?

I don't see this in the Netezza documentation. We have lots of Linux scripts where we do this: NZ_PASSWD_ENCRYPTED=29TY20T98= NZ_PASSWD_CLEAR=`DecryptFunc $NZ_PASSWD_ENCRYPTED` NzResult=$(nzsql -db $...
Andrew Wolfe's user avatar
0 votes
1 answer
4k views

Netezza LIKE operator not finding subsequent backslashes

Netezza is able to find records when using the LIKE operator when the first character contains a backslash character. But when subsequent characters contain a backslash character, it cannot. How can ...
JustBeingHelpful's user avatar
2 votes
2 answers
35k views

How to obtain row counts for all tables in Netezza?

Is there a system table or view in Netezza that shows the number of records for each table?
user2462699's user avatar
1 vote
1 answer
941 views

Netezza Equivalent to T-SQL ROWVERSION or PL/SQL ORA_ROWSCN

Is there a Netezza equivalent to the MSSQL ROWVERSION or the Oracle ORA_ROWSCN? Essentially I'd like to know if a record changed and be confident that it changed. Using a checksum isn't reliable 100%...
JustBeingHelpful's user avatar
2 votes
1 answer
2k views

Installing Netezza 6.0.8 ODBC driver on Windows Server 2008

Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set ...
JustBeingHelpful's user avatar
1 vote
2 answers
2k views

How do I migrate varbinary data to Netezza?

I got a warning message while migrating DDL from SQL Server to Netezza: Warning: [dbo].[spec_binarymessage].[blobdata] data type [varbinary] is not supported the target system and will be scripted ...
Jane's user avatar
  • 11
1 vote
2 answers
3k views

Obvious inefficiencies in this Netezza query?

Why might this query be taking nearly 2 hours to run when similar queries complete within a minute? CREATE TABLE T3 AS SELECT A.*, COALESCE(C.FIELD1,0) AS FIELD1A, COALESCE(...
jl6's user avatar
  • 805
9 votes
4 answers
20k views

What can speed up a SQL count query?

When doing a count (aggregate) SQL query, what can speed up the execution time in these 3 database systems? I'm sure many things could speed it up (hardware for one), but I'm just a novice DBA, so I'...
JustBeingHelpful's user avatar
1 vote
1 answer
11k views

Table schema column data type equivalents for Netezza 6 to SQL Server 2008

I'm trying to find a data type equivalents for data types in Netezza when migrating table schema to SQL Server. Where can I find a complete list? When getting down to brass tacks, I am specifically ...
JustBeingHelpful's user avatar
1 vote
2 answers
8k views

How can primary keys in a Netezza table be indexed?

What is the best way to index a Netezza fact table with lots of primary keys. For now, let's suppose we have 10 primary keys. This table is mainly used to store meta data about our database. =====...
JustBeingHelpful's user avatar
1 vote
1 answer
885 views

Tools for synchronizing database schema with Oracle, SQL-Server and Netezza databases [closed]

I'm looking for software tools to move database schema for Oracle, SQL Server and Netezza. We use Oracle for our ODS, Netezza for our Data Warehouse (for it's bulk loading capabilities) and SQL ...
JustBeingHelpful's user avatar