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 – How to build a multi table drop command from a select

How to Quick Drop Multiple Tables occasionally, there is a need to quickly drop a list of tables and you don't always want to write or generate each command individually in Aginity.  So, here is a quick example of how you can use a 'Select' SQL statement to generate a list of drop commands for you. Now, … Continue reading Netezza / PureData – How to build a multi table drop command from a select

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

Aginity for Netezza – How to Display Query Results in a Single Row Grid

Displaying your Netezza query results in a grid can be useful.  Especially, when desiring to navigation left and right to see an entire rows data and to avoid the distraction of other rows being displayed on the screen. I use this capability in Aginity when I’m proofing code results and/or validating data in a table. … Continue reading Aginity for Netezza – How to Display Query Results in a Single Row Grid

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

How to get a previously run SQL in Aginity

Every once and a while, it happens that a SQL needs to be reused, but for whatever reason it was not saved.  If it wasn’t too far back in time, you can recover the SQL from the User Query History.  This is a fairly straight forward process, if not exactly obvious. The basic process is: … Continue reading How to get a previously run SQL in Aginity