Netezza / PureData – How To Quote a Single Quote in Netezza SQL

How To Quote a Single Quote in Netezza SQL? The short answer is to use four single quotes (''''), which will result in a single quote within the select statement results. How to Assemble the SQL to Quote a Single Quote in a SQL Select Statement Knowing how to construct a list to embed in … Continue reading Netezza / PureData – How To Quote a Single Quote in Netezza SQL

Netezza / PureData – Aginity for Netezza shortcut key list

Recently, while working with a couple of my teammates on different projects I picked up a couple shortcut keys for Aginity for netezza, which I did not know existed. So, I thought about be nice to put a list of shortcut keys for future reference. I don't use most of them very often, but I … Continue reading Netezza / PureData – Aginity for Netezza shortcut key list

Netezza / PureData – Substring Function On Specific Delimiter

The function Substring (SUBSTR) in Netezza PureData provides the capability parse character type fields based on position within a character string.  However, it is possible, with a little creativity, to substring based on the position of a character in the string. This approach give more flexibility to the substring function and makes the substring more … Continue reading Netezza / PureData – Substring Function On Specific Delimiter

PureData / Netezza – What date/time ranges are supported by Netezza?

Here is a synopsis of the temporal ranges ( date, time, and timestamp), which Netezza / PureData supports. Temporal Type Supported Ranges Size In Bytes Date A month, day, and year. Values range from January 1, 0001, to December 31, 9999. 4 bytes Time An hour, minute, and second to six decimal places (microseconds). Values … Continue reading PureData / Netezza – What date/time ranges are supported by Netezza?

Aginity Workbench for PureData /Netezza System for Analytics – Useful links

  Here are some Aginity Workbench for Netezza references, which I have found useful. Reference Type Link Aginity Workbench for Netezza http://www.aginity.com/workbench/netezza/ Aginity Workbench for Netezza Documentation http://www.aginity.com/documentation/WB/NZ/ Related References Aginity for Netezza – How to disable and/or Enable the Autocomplete Function How to get a previously run SQL in Aginity

Aginity for Netezza – How to disable and/or Enable the Autocomplete Function

Aginity for Netezza an out complete feature, which auto completes brackets, quotes, and comment character, which some folks find useful and helpful.  However, if you are an old-school style coder like me, you may find these annoying, to say the least.  Usually, when I’m coding I want to write straight through without the need to … Continue reading Aginity for Netezza – How to disable and/or Enable the Autocomplete Function

PureData / Netezza – Useful links

IBM Netezza / IBM PureData for Analytics Here are a few Netezza references, which I have found useful. Reference TypeLinkVendor Documentationhttps://www.ibm.com/support/knowledgecenter/SSULQD_7.2.0/com.ibm.nz.welcome.doc/doc/welcome.htmlIBM Developer Workshttps://www.ibm.com/developerworks/community/groups/service/html/communitystart?communityUuid=9c8f1300-9ac0-4de5-80e6-0Aginity Workbench for Netezzahttp://www.aginity.com/workbench/netezza/IBM Netezza Database User's Guidehttps://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.0/com.ibm.nz.dbu.doc/c_dbuser_ntz_sql_introduction.htmlClient Software Packageshttps://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.0/com.ibm.nz.adm.doc/c_sysadm_client_software_packages.html Netezza Client Software Installationhttps://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.0/com.ibm.nz.adm.doc/c_sysadm_client_software_install.html Related References PureData – Current Date FunctionPureData – Now() Command For Current DateNetezza/PureData – Row Number FunctionNetezza/PureData SQL Date Formatting … Continue reading PureData / Netezza – Useful links