Netezza data types and functions

Standard
Here is a list of data types along with associated info. Note that this is generated by “SQuirrel” tool using Netezza JDBC. These data types are likely applicable to both 5.x and 6.x.
TYPE_NAME DATA_TYPE PRECISION NULLABLE CASE_SENSITIVE MAXIMUM_SCALE
NVARCHAR -9 [NVARCHAR] 16000 true true 0
NCHAR -8 [ROWID] 16000 true true 0
BOOLEAN -7 [BIT] 1 true false 0
BYTEINT -6 [TINYINT] 4 true false 0
BIGINT -5 [BIGINT] 20 true false 0
CHAR 1 [CHAR] 64000 true true 0
NUMERIC 2 [NUMERIC] 38 true false 37
DECIMAL 3 [DECIMAL] 38 true false 37
INTEGER 4 [INTEGER] 11 true false 0
SMALLINT 5 [SMALLINT] 6 true false 0
FLOAT 6 [FLOAT] 7 true false 6
REAL 7 [REAL] 7 true false 14
DOUBLE 8 [DOUBLE] 15 true false 14
VARCHAR 12 [VARCHAR] 64000 true true 0
DATE 91 [DATE] 10 true false 0
TIME 92 [TIME] 15 true false 6
TIMESTAMP 93 [TIMESTAMP] 26 true false 6
INTERVAL YEAR 101 [UNKNOWN] 50 true false 0
INTERVAL MONTH 102 [UNKNOWN] 50 true false 0
INTERVAL DAY 103 [UNKNOWN] 50 true false 0
INTERVAL HOUR 104 [UNKNOWN] 50 true false 0
INTERVAL MINUTE 105 [UNKNOWN] 50 true false 0
INTERVAL SECOND 106 [UNKNOWN] 50 true false 0
INTERVAL YEAR TO MONTH 107 [UNKNOWN] 50 true false 0
INTERVAL DAY TO HOUR 108 [UNKNOWN] 50 true false 0
INTERVAL DAY TO MINUTE 109 [UNKNOWN] 50 true false 0
INTERVAL DAY TO SECOND 110 [UNKNOWN] 50 true false 0
INTERVAL HOUR TO MINUTE 111 [UNKNOWN] 50 true false 0
INTERVAL HOUR TO SECOND 112 [UNKNOWN] 50 true false 0
INTERVAL MINUTE TO SECOND 113 [UNKNOWN] 50 true false 0
TIMETZ 1266 [UNKNOWN] 21 true false 6
           
Supported refactoring: If Netezza allows or disallows database commands. For instance, we can not create an index.
           
Key Value        
supportsAddColumn FALSE        
supportsAlterColumnNull FALSE        
supportsAlterColumnType FALSE        
supportsCreateIndex FALSE        
supportsDropColumn FALSE        
supportsDropIndex FALSE        
supportsAddForeignKeyConstraint TRUE        
supportsAddPrimaryKey TRUE        
supportsAddUniqueConstraint TRUE        
supportsAlterColumnDefault TRUE        
supportsAlterSequence TRUE        
supportsCreateSequence TRUE        
supportsCreateTable TRUE        
supportsCreateView TRUE        
supportsDropConstraint TRUE        
supportsDropPrimaryKey TRUE        
supportsDropSequence TRUE        
supportsDropView TRUE        
supportsRenameColumn TRUE        
supportsRenameTable TRUE        
supportsRenameView TRUE        
           
           
Numeric Functions String Functions        
 acos  lcase        
 asin  length        
 atan  locate        
 atan2  ltrim        
 ceiling  rtrim        
 cos  substring        
 cot  ucase        
 degrees concat        
 exp          
 floor          
 log          
 log10          
 mod          
 pi          
 power          
 radians          
 rand          
 round          
 sign          
 sin          
 sqrt          
 tan          
 truncate          
abs          

 

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s