Netezza

Run Netezza SQL Script File using nzsql Variable Substitution

Netezza allows the variable substitution using -v option in Netezza nzsql queries. The variable substitution is very important when you are calling the Netezza nzsql scripts from shell or any other scripting language. You can pass the values to query that you are calling using -v option. In this article, we will see how to run Netezza nzsql script file using nzsql variable substitution. We also see some of the working examples that uses the Netezza variable substitution method. Run Netezza SQL Script File using nzsql Variable Substitution You can set…

Continue ReadingRun Netezza SQL Script File using nzsql Variable Substitution
Comments Off on Run Netezza SQL Script File using nzsql Variable Substitution
June 4, 2017
Netezza

Netezza Update Join Syntax – Update using other Table

Every application that require the data; data storage is very much important. In the digital world, we use databases (in fact tables) to store information. Data is collected over the time and it may or may not be accurate. In some cases you may want to update the table based on the data available in other table over same or other database on same server. In this article, we have explained the Netezza Update Join Syntax and example on how to update using Data in other Table. Read: How Netezza…

Continue ReadingNetezza Update Join Syntax – Update using other Table
Comments Off on Netezza Update Join Syntax – Update using other Table
February 9, 2017
Netezza

Netezza Organize On Syntax and Examples

The Netezza Organize on is one of important feature introduced in the Netezza data warehouse appliance. With the help of Organize on keys, you can create the clustered base tables (CBT). You can specify up to four columns in organize on key. Read: Cluster Based Tables - CBT Netezza TwinFin Architecture IBM Netezza nzsql Command and its Usage Netezza ALTER TABLE Command Netezza Organize On Keys IBM Netezza Organizing keys are useful for the more frequently used columns that you specify as keys are used in query predicates, alone or in…

Continue ReadingNetezza Organize On Syntax and Examples
Comments Off on Netezza Organize On Syntax and Examples
February 9, 2017
Netezza

Netezza Unique Key Constraint and Syntax

Netezza nzsql supports SQL-92 standard. Netezza data warehouse appliance supports referential integrity such as Netezza unique key, primary key, and foreign keys as part of SQL-92 standard requirement. You can create Netezza unique key constraint while creating tables in Netezza database but it will not be enforced while loading Netezza tables. Read: Netezza nzsql command and its Usage Netezza Primary Key Constraint and Syntax Netezza Foreign Key Constraint and Syntax In this post we will learn about the Netezza unique key constraints and its syntax. Netezza Unique Key Constraint Syntax and Example…

Continue ReadingNetezza Unique Key Constraint and Syntax
Comments Off on Netezza Unique Key Constraint and Syntax
November 19, 2016
Netezza

Netezza Foreign Key Constraint and Syntax

Netezza nzsql supports SQL-92 standard. Netezza data warehouse appliance supports referential integrity such as Netezza foreign key, primary key, and unique keys as part of SQL-92 standard requirement. You can create Netezza foreign key constraint while creating tables in Netezza database but it will not be enforced while loading Netezza tables. Read: Netezza nzsql command and its Usage Netezza Unique Key Constraint and Syntax Netezza Primary Key Constraint and Syntax In this post we will learn about the Netezza foreign key constraints and its syntax. Netezza Foreign Key Constraint Syntax and…

Continue ReadingNetezza Foreign Key Constraint and Syntax
1 Comment
November 19, 2016
Netezza

Netezza Primary Key Constraint and Syntax

Netezza nzsql supports SQL-92 standard. Netezza data warehouse appliance supports referential integrity such as Netezza primary key, foreign key, and unique keys as part of SQL-92 standard requirement. You can create Netezza primary key constraint while creating tables in Netezza database but it will not be enforced while loading Netezza tables. Read: Netezza Create Table Command and Examples Netezza Unique Key Constraint and Syntax Netezza Foreign Key Constraint and Syntax In this post we will learn about the Netezza primary key constraints and its syntax. Netezza Primary Key Constraint Syntax…

Continue ReadingNetezza Primary Key Constraint and Syntax
Comments Off on Netezza Primary Key Constraint and Syntax
November 19, 2016
Netezza

Netezza MERGE command to Manipulate Records from Table

Use the Netezza MERGE command to insert, update, or delete rows in a target table using data from a source such as a table, view, or sub-query and based on rules specified for a matching condition in the merge statements. In the Netezza merge command, you must specify at least one matching_condition statement to identify the rows that you want to update, insert or delete. This feature is not supported in all versions of Netezza. IBM has introduced this feature in Netezza 7.2.1 or higher. MEGRE command is used to…

Continue ReadingNetezza MERGE command to Manipulate Records from Table
Comments Off on Netezza MERGE command to Manipulate Records from Table
October 20, 2016
Netezza

Changing Netezza Table Distribution key and Example

Choosing right distribution key is one of the important factor to improve the performance of Netezza server. If you have created the table with RANDOM distribution or with different column with lots of duplicate records then you should immediately change the distribution key otherwise that will reduces the performance. Changing Netezza table distribution key is process of redistributing the Netezza table using Netezza nzsql. Changing Netezza Table Distribution key and Example You can achieve the redistribution in couple of ways: Redistribute using CTAS Creating new table and loading data at…

Continue ReadingChanging Netezza Table Distribution key and Example
1 Comment
October 15, 2016
Netezza

Netezza Encrypt Password with nzpassword Command Utility

Database user accounts must be authenticated during access requests to the IBM Netezza database. You can secure the password by using Netezza encrypt password facility. Local authentication requires a password for every account which connects to the Netezza server. You must enter the clear text password, when you use Netezza CLI commands. You can set the environment variable NZ_PASSWORD to avoid the type of password every time but this variable also stores the clear text password. Read: Commonly used Netezza Utility Netezza Best Practices to Improve Performance Netezza nzsql Commands and…

Continue ReadingNetezza Encrypt Password with nzpassword Command Utility
Comments Off on Netezza Encrypt Password with nzpassword Command Utility
October 4, 2016
Netezza

Netezza Cross Database Access and its Restrictions

Netezza cross database access does allows you to execute the objects such as tables, view, synonyms that are available on the same Netezza server. You can can INSERT, UPDATE or DELETE data from current database by referring objects in other database on same server. For example, TRAINING1.ADMIN(ADMIN)=>SELECT * FROM TRAINING1..TEST1; Read: Access Netezza Database, Tools and Examples Netezza nzsql Command and its Usage Netezza Synonym Best Practices and Examples Referencing Database Object from other Database To access objects in other databases on the same Netezza system, you must use three-level…

Continue ReadingNetezza Cross Database Access and its Restrictions
Comments Off on Netezza Cross Database Access and its Restrictions
September 28, 2016