(Todd Leyba) Now you can add IBM OmniFind search functionality to a conventional Lotus Notes database application accessed through the Notes client. Specifically, in this article you’ll learn how to call IBM’s Java Search and Indexing API (SIAPI) from within LotusScript. In addition to showing you h
Other News
Distributed Partitioned Views / Federated Databases: Lessons Learned
(Kevin Cox, Teodoro Marinucci and Silvia Bevilacqua) This article contains information about the things we have learned while working with Federated Databases. Before beginning it is necessary to define the terms being used. Included in this article is one solution in production that is using fede
Ask and you shall receive
(Chris Eaton) Ok so maybe not every feature request makes it into the product. But last fall I wrote a blog posting on the new MERGE statement in DB2. Lewis (my favorite Oracle blogger) jokingly wrote in a comment. “Now if you guys would just get with the program and add DECODE all would be good!
Creating Custom Installer Dialogs for Visual Studio Setup Projects
(Shaun Wilde) The Visual Studio setup projects that come installed as part of Visual Studio are handy for knocking out quick-and-easy installers, but they are a bit limited in scope. Two main drawbacks are: –You have only a limited number of dialogs to choose from, which can easily run out on a
Create an asynchronous message framework with Ajax and Apache Geronimo
(Jeff Hanson) Combine Apache Geronimo with an Asynchronous JavaScript + XML (Ajax) user interface (UI), an asynchronous messaging system, and loosely coupled business services to build a responsive, enterprise-grade Web application framework.
Rolling Sums in SQL – A Practical Example
(Jay Pipes) Today, Lenz was putting together some stats on PlanetMySQL feeds added since January this year, and asked in an email whether he should include totals in the stats. I responded yes, and offered a quick SQL solution to get those numbers out of the database. I thought it might be useful fo
What DB2 Means to Business Value
(Robert Catterall) Many of you can delve into the details of DB2 technology with ease, speaking with confidence about the particulars of query parallelization, data compression, WebSphere MQ integration, large object management, JDBC and ADO.Net drivers, data sharing on a mainframe Parallel Sysplex,
SqlCredit Part 6: Exploring EncryptByCert and DecryptByCert
(Rob Garrison) There are many good articles available that cover data encryption and data security in general. I will not try to explain why you need to encrypt sensitive data within your database. If you don’t already have someone knocking on your door telling you to do this, listen carefully and y
XML: Include a flexible parser in your C++ applications
(Michael Chourdakis) Are you tired of the many non-portable XML solutions around? Try my library. It works in any OS and in any compiler. No MFC, no COM, no global variables, no STL, no exceptions. Plain, pure C++!
Handling No Namespace Schemas within your BPEL Processes
(Ramkumar Menon) There could be cases where you might end up referring to unqualified elements/attributes in yout BPEL Processes. Unqualified means that the elements/attributes are defined in null/no namespace.