My belated New Year's resolution: Switch to using CLPPlus
I didn't post a new blog entry past Monday because I had to prepare for a DB2 class I was teaching that Thursday.
As part of this class I also wanted to provide some live demos of various SQL features.
Traditionally my standard means of testing features on DB2 is the Command Line Processor (CLP) which you start with "db2".
With DB2 9.7 however a new contender has arrived. The name of this shell is CLPPlus.
So, for this class that I taught I choose CLPlus just to show it of to true blue customers.
I am thrilled!
The first and foremost goal of this new command line processor has been to ingest scripts written to Oracle's SQL*Plus and to provide a familiar environment for Oracle DBAs who are exposed to DB2 for the first time.
For that reason the IBM India team which develops and supports the tool has made CLPPlus compatible with SQL*Plus.
Therefore the name CLPPLus is, of course, no accident.
But CLPPlus is so much more than just a means to make Oracle DB2 happy.
It provides functionality you may very well have missed in CLP for a long time.
And that is why I believe that DB2 or IDS users should take a close look here.
A few highlights of what CLPPlus can do that CLP cannot:
In this post I don't want to re-iterate the reference manuals. Instead let me provide a set of links with videos and other overviews along with my commitment to use CLPPlus moving forward whenever I can. In that progress I will introduce features as they naturally occur.
Give CLPPlus a whirl!