My BI World

IBM Infosphere Datastage, Netezza, Microstrategy, SSIS, SSRS,Hadoop, BI, ETL, Data warehouse, SQL Server, Tableau, mongoDB

Wednesday, December 12, 2012

Netezza SQL Extension Toolkit

There are many useful string manipulation functions in Netezza available if you install Netezza SQL Extension Toolkit.

To get the Right 3 characters of a string:

select strright( 'this is a string abc',  3)

The above will return abc.


Posted by Tenny Susanto at 1:36 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Netezza

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • Datastage
  • Hadoop
  • Hive
  • Impala
  • Microstrategy
  • Mongodb
  • Netezza
  • Pig
  • Scripting
  • Shell scripting

Blog Archive

  • ►  2014 (4)
    • ►  October (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2013 (19)
    • ►  December (1)
    • ►  November (8)
    • ►  August (2)
    • ►  June (1)
    • ►  March (2)
    • ►  February (3)
    • ►  January (2)
  • ▼  2012 (14)
    • ▼  December (3)
      • Hadoop etc
      • Netezza SQL Extension Toolkit
      • Microstratgy Dashboard
    • ►  September (3)
    • ►  August (8)

Popular Posts

  • Useful Netezza Date Functions
  • Netezza External Tables
  • Netezza update based on a table join
  • How to run Microstrategy Tutorial documents / dashboards
  • Hive / Impala - create external tables with data from subfolders
  • Deduping rows in Netezza / Deleting rows in Netezza.
  • shell scripting cheatsheet
  • Custom Group vs Attribute ApplySimple in Microstrategy
  • Netezza regexp_like. Regex to find integers only
  • Sort a graph on a Microstrategy dashboard
Awesome Inc. theme. Powered by Blogger.