SQL server table Describe (DESC) equivalent

Transact SQL (T-SQL) Microsoft SQL Server doesn’t seem have a describe command and usually, folks seem to want to build a stored procedure to get the describe behaviors.  However, this is not always practical based on your permissions. So, the simple SQL below will provide describe like information in a pinch.  You may want to … Continue reading SQL server table Describe (DESC) equivalent

Netezza / PureData – Table Describe SQL

If you want to describe a PureData / Netezza table in SQL, it can be done, but Netezza doesn’t have a describe command.  Here is a quick SQL, which will give the basic structure of a table or a view.  Honestly, if you have Aginity Generating the DDL is fast and more informative, at least … Continue reading Netezza / PureData – Table Describe SQL

Aginity For Netezza – How to Generate DDL

How to Generate Netezza Object DDL In ‘Aginity for Netezza’ this process is easy, if you have a user with sufficient permissions. The basic process is: In the object browser, navigate to the Database select the Object (e.g. table, view, stored procedure) Right Click, Select ‘Script’ > ‘DDL to query window’ The Object DDL will … Continue reading Aginity For Netezza – How to Generate DDL

Netezza / PureData – Substring Function Example

The function Substring (SUBSTR) in Netezza PureData provides the capability parse character type fields based on position within a character string. Substring Functions Basic Syntax SUBSTRING Function Syntax SUBSTRING(<<CharacterField>>,<< StartingPosition integer>>, <<for Number of characters Integer--optional>>)   SUBSTR Function Syntax SUBSTR((<>,<< StartingPosition integer>>, <>)   Example Substring SQL Substring SQL Used In Example SELECT  LOCATIONTEXT … Continue reading Netezza / PureData – Substring Function Example

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

Netezza / PureData – Position Function

  The position function in Netezza is a simple enough function, it just returns the number of a specified character within a string (char, varchar, nvarchar, etc.) or zero if the character not found. The real power of this command is when you imbed it with character function, which require a numeric response, but the … Continue reading Netezza / PureData – Position Function

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?