Netezza / PureData – What client tools to use with Netezza

Occasionally, a client will want a list of tools to work with Netezza / PureData, other than the Netezza Administrator Client.  Honestly, there are several tools which could be used, if they have odbc and/or jdbc connectivity.  However, these are the tools which keep being used across different customers. Open Source For customers willing to … More Netezza / PureData – What client tools to use with Netezza

Infosphere Datastage – Data type conversions from Netezza to DataStage

Some recent research to eliminate some ETL Data Conversion issues, made me want to make an enhancement to the documentation provided by IBM, to prevent repeating the research. Netezza data types and their equivalent InfoSphere DataStage data types Netezza data types InfoSphere DataStage data types (SQL types) Notes   BYTEINT TinyInt     SMALLINT SmallInt     INT … More Infosphere Datastage – Data type conversions from Netezza to DataStage

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 … More Aginity for Netezza – How to disable and/or Enable the Autocomplete Function

Netezza / PureData – What is the maximum length of CHAR, VARCHAR, and NVARCHAR fields

During a recent project, I had reason to investigate what the maximum character field links for Netezza to be able to fit the data ETL ‘ed from the source.  The constraints on Netezza character fields are not as long as some other databases, therefore, I thought I would document and a quick post for future … More Netezza / PureData – What is the maximum length of CHAR, VARCHAR, and NVARCHAR fields

Netezza / PureData – how to convert an integer to a date

Lately, I have been encountering a lot of date fields stored as integer.  So, I thought it might be useful to write a quick post on how to convert a date stored as an integer to a date.   The process is quite easy and intuitive, here are a few approaches for doing so. Basic To_Date Command … More Netezza / PureData – how to convert an integer to a date