Netezza / PureData – Casting Numbers to Character Data Type

I noticed that someone has been searching for this example on my site, so, here is a quick example of how to cast number data to a character data type.  I ran this SQL example in netezza and it worked fine. Basic Casting Conversion Format cast(<<FieldName>> as <<IntegerType_or_Alias>>) as <<FieldName>>   Example Casting Number to … Continue reading Netezza / PureData – Casting Numbers to Character Data Type

Infosphere DataStage – Boolean Handling for Netezza

  Beware when you see this message when working with Boolean in DataStage, the message displays as informational (at list it did for me) not as a warning or an error.  Even though it seems innocuous, what it meant for my job, was the Boolean (‘true’ / ‘false’) was not being interpreted and everything posted … Continue reading Infosphere DataStage – Boolean Handling for Netezza

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

IBM Netezza / IBM PureData for Analytics 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 … Continue reading Netezza / PureData – What is the maximum length of CHAR, VARCHAR, and NVARCHAR fields

Netezza / PureData – SQL Cast Conversion to Integers

Cast Conversion Format From time to time, I have had to look up this information, especially, when working with old school SQL intensive ETL patterns where the transformations are being performed in SQL rather within the ETL application.  So, rather than scrambling to find the differing integer casting range limits, bit type conversions, and alias for … Continue reading Netezza / PureData – SQL Cast Conversion to Integers