(Rav Ahuja) This demo shows the new Command Line Processor – CLP Plus in DB2 9.7. CLP Plus makes it easy to edit and execute SQL statements, scripts, reports, procedures, functions, etc. It also supports scripts written for Oracle SQL*Plus.
Tag: IBM
Automating service document deployment with the WebSphere Service Registry and Repository promotion feature
(Shenfu (Mike) Fan) WebSphere Service Registry and Repository plays an important role in SOA as a master metadata repository for service documents and other artifacts. This article introduces the new WebSphere Service Registry and Repository promotion feature and shows you how to use if for automati
SQL Tips & Techniques- String Splitting
(Radhesh Kumar) In my previous post SQL Tips & Techniques- String Aggregation, I discussed how to perform string aggregation. Recently, I received a question to do the reverse using SQL i.e. String Splitting.
Decrease IT Costs with IBM DB2 9.7
Everyone is cutting costs and keeping a close eye on spending, but for far too many organizations cutting costs also means cutting projects that could help the business grow.
Comparing IBM DB2 and IBM solidDB SQL procedures, Part 2: Compare conditional statements, looping statements, error handling, and returning results sets in SQL procedures
(Nora Sokolof) Have you ever wondered how IBM DB2 and IBM solidDB procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 2, learn the differences between conditional statements, looping statements, error handling, returning results sets, and misce
DB2 9.7: Online Schema Change
(Rav Ahuja) This demo shows the new Online Schema Change feature in DB2 9.7 which makes databases mor available by allowing definitions of objects like tables and views to be changes on-the-fly without interrupting access by users and applications.
DB2 Express-C 9.7 and the Django adapter released
(Antonio Cangiano) This is a great day for those of us who love DB2, as DB2 Express-C 9.7 has just been released. As mentioned before, this is the best DB2 ever, and an extremely important release.
Compare the Informix Dynamic Server, Version 11 editions
(Carlton Doe) Confused about the various editions of IBM Informix Dynamic Server (IDS)? In this article you’ll get an introduction to each edition, and then you can compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, IDS brings yo
Sometimes it’s just a numbers game; international, national, and local user groups
(Willie Favero) “Remember the good old days!” We all find ourselves falling into that bad habit of remembering how good we thought things used to be way back when and comparing those days gone by to current situations, usually a situation you are unhappy with today. However, in reality, a lot of the
Lessons from the field (again): Remember the trees!
(Henrik Loeser) In April I had already written about the nice surprises XML and XQuery have for developers. XQuery and XPath operate on the tree representation of a document and in most cases those trees have more than one branch. This is something to keep in mind, always!
