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
Netezza

Netezza Interval Data Types and Conversion Examples

Netezza interval data types are supported in different way. Netezza accepts the interval syntax, but ignores the unit specification. All intervals are the same, and can contain values of any combination of units. Netezza server internally normalizes all intervals to units of seconds. It considers a month to be 30 days for the purposes of interval comparisons and this approximation may lead to inaccuracy. Netezza Interval Data Types Implementation IBM Netezza implements the INTERVAL data type in a different way compared to other databases. Netezza allows you to specify interval…

Continue ReadingNetezza Interval Data Types and Conversion Examples
Comments Off on Netezza Interval Data Types and Conversion Examples
September 23, 2016
Netezza

Netezza Internal DataTypes: rowid, createxid, deletexid and datasliceid

Netezza supports internal datatypes that are used by system to perform internal tasks on the table records. Netezza internal datatypes includes: rowid, transaction ID (createxid, deletexid), and dataslice. Shows Netezza internal Datatypes: Internal Datatype Column Name rowid rowid transaction ID Createxid deletexid dataslice datasliceid Netezza Internal DataTypes: Rowid Identifies a specific and unique record in the database. These row numbers are not necessarily sequential within a table. Usually, the initial rowid value is 100,000. The Netezza host assigns a range of sequential rowids to each SPU in the system. When…

Continue ReadingNetezza Internal DataTypes: rowid, createxid, deletexid and datasliceid
Comments Off on Netezza Internal DataTypes: rowid, createxid, deletexid and datasliceid
September 23, 2016
Netezza

Netezza String Functions and its Usage with Examples

Netezza String Functions are used primarily for string manipulation. An IBM Netezza also supports some of the standard string function along with the PostgreSQL specific functions. Netezza String Function Usage Below is the list of Netezza String functions supported: Function Name Description ascii(s) Returns the numeric ASCII value of the first character in the text string. btrim(s) Trims spaces from both ends of the string. btrim(s,t) Trims occurrences of the characters in string t from bothe ends of string s chr(n) Returns the character with the specified ASCII value. initcap(s) Capitalizes the…

Continue ReadingNetezza String Functions and its Usage with Examples
2 Comments
September 21, 2016
Netezza

Netezza Extract Function Usage and Examples

Netezza extract function extracts the sub field represented by units from the date/time value, interval, or duration specified for column. This function is equivalent to Netezza date_part() function. Netezza Extract Function Syntax extract(units FROM col) Netezza Extract Function Usage Below table represents the descriptions of the different units used in extract function: Unit Value Description epoch The number of seconds since 1970-01-01 00:00:00-00. The value can be positive or negative. millennium/millenniums The millennium value. century/centuries The number of full 100-year periods represented by the year. decade/decades The number of full 10-year periods represented by the…

Continue ReadingNetezza Extract Function Usage and Examples
Comments Off on Netezza Extract Function Usage and Examples
September 20, 2016
Netezza

Explicit and implicit Netezza Type Casting With Examples

Netezza type casting is converting the value with one data type to other. There are two type of type casting: Implicit and Explicit type casting. Implicit Netezza Type Casting In an implicit type casting Netezza uses internal rules and try to evaluate the process statements that contain the mixed data types. This will be very helpful when using a function that expects a particular data type, or when issuing a query that compares values that are similar but of different data types. For example, Consider the below query that compare…

Continue ReadingExplicit and implicit Netezza Type Casting With Examples
1 Comment
September 17, 2016
Data Warehouse

Different Extraction Methods in Data Warehouse

Extraction is the first step of the ETL(Extract, Transform and Load) process. Once the data is extracted, you can transform it and load to target data warehouse. Extraction is the process of extracting data from the source system for further use in the data warehouse environment. Related Reading: Data Warehouse Fact Constellation Schema and Design Star Schema model in Data Warehouse Snowflake Schem Model in Data Warehouse Data warehouse is an OLAP system, typically source system includes the transaction business processing application. For example, it could be sales order entry…

Continue ReadingDifferent Extraction Methods in Data Warehouse
2 Comments
September 16, 2016
Netezza

Netezza Hash Function Usage and Examples

You can use Netezza hash function to encode the data by transforming the input into a hash code or hash values. If you use the hash function, no two inputs have same hash values. The hash algorithm is designed to minimise the collision (two inputs having same hash value). You can use the hash function to speed up the data record retrieval by using simple one way lookup. Hash code is used as an index into a hash table which has a pointer to data records. Netezza hash function also…

Continue ReadingNetezza Hash Function Usage and Examples
Comments Off on Netezza Hash Function Usage and Examples
September 14, 2016
Netezza

Netezza Correlated Subquery and its Restrictions

Netezza Correlated subquery is a query within a query that refer the columns from the parent or outer query. Netezza does support the regular and correlated subqueries. In most cases, the Netezza correlated subqueries are used to improve the SQL query performance. Netezza Correlated Subquery Example For example, consider query, “check if department is already exists in the patient table before selecting it from patient department table”. We can correlate both tables and write sql query. You can write the SQL as below: SELECT T1.DEPT_CD , DATA_SRC_CD , T1.DEPT_NM FROM…

Continue ReadingNetezza Correlated Subquery and its Restrictions
Comments Off on Netezza Correlated Subquery and its Restrictions
September 14, 2016
Netezza

Download and Configure Netezza Linux ODBC Driver

This section describes you about downloading, configuring and testing Netezza Linux ODBC driver. This process is tested on the Ubuntu 14.04. Netezza Linux ODBC Drivers are requires to connect to Netezza server from any client machine. Read: Install vmware player and Netezza emulator on Ubuntu Connecting Netezza using Python pyodbc - Working ExampleNetezza FPGA nzsql Command and its Usage nzload command and its Usage Download Netezza Linux ODBC Driver You can download Netezza Linux ODBC Driver from Netezza fix central page. Below is url for your reference: https://www-945.ibm.com/support/fixcentral/ Note that, IBM…

Continue ReadingDownload and Configure Netezza Linux ODBC Driver
Comments Off on Download and Configure Netezza Linux ODBC Driver
September 14, 2016