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

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