(Jochen Dörre, Josemina Magdalen, Wendi Pohs and Bob St. Clair) Employ professional tools for taxonomy management and auto-classification to enhance enterprise search solutions built with IBM OmniFind Enterprise Edition. Use SchemaLogic’s Enterprise Suite to centrally maintain a consolidated enterpr

(Willie Favero) Ever write an application that has to have logic to determine if a row exists before it is inserted. If the row doesn’t exist, the row is inserted. However, if the row does exist, then you have to do an update. You have to code multiple SQL statements, if it’s a distributed applicati

(Paul Tuohy) I am sure you have heard that SQL is now the preferred means of defining a database as opposed to traditional RPG. You may be under the impression that this does not affect you since you are not defining any new databases, just using the ones you have been using for years. (R)

(Blayne Chard) Create a simple DataStage operator, then learn how to load the operator into DataStage Designer. An operator is the basic building block of a DataStage job. Operators can read records from input streams, modify or use the data from the input stream, and then write the results to a out

(Stacy Cowley) IBM is offering an expanded slate of sales and technical support around its free, entry-level WebSphere Application Server and DB2 products, a move aimed at wooing solution providers drawn to the low cost and easy accessibility of open-source offerings.

(Vincent McBurney) An IBM Developerworks article shows how to configure the remote DB2 Enterprise stage and benchmarks it as 250% faster than a standard API connection.

(Dave Warner) Document storage is hot, hot, hot! There has been an explosion of methodologies and tool sets — both open source and proprietary — to fulfill the demand for quickly locating and searching documents. Enabling technologies like Alfresco, Sharepoint, or my favorite, TWiki, are powerful,

(Michael Sansoterra) Last October, I wrote about learning how to write Microsoft .NET code using one of the free Visual Studio Express Editions. In this tip, I continue with the “free” motif by describing a few of the free database engines that are available.

(Willie Favero) Have you been out on the DB2 for z/OS Version 8 Books website lately? You should. As I am always suggesting, you need to visit this page frequently to make sure that you are always working from the most up-to-date information.

(Cheung-Yuk Wu and Marion Behnen) IBM DB2 Data Warehouse Edition SQL Warehousing Tool provides variables and variable groups to enable you to customize your data transformations and work flows. Optimize your DB2 Data Warehouse Edition flow design with a good understanding of variable usage in order