(Joe Pluta) In my previous article on this topic, I explained why the best combination for programming business rules is RPG and DB2. I debunked the four Ps of the naysayers: performance, productivity, platform independence, and programmers. In so doing, I clearly outlined why there is a strong and

(Peggy Rader) Understand what your Java Software Development Kit (SDK) selection options are when you use the DB2 Development Center (DC) to create Java stored procedures on OS/390 and z/OS platforms. Also, apply this information when you create Java stored procedures in the WebSphere Studio product

Getting the most from today’s complex database systems is a challenge. Learn how self-managing capabilities in DB2 UDB v.8.2 do some of the work for you. (R)

(Rajesh Kartha) This article introduces you to ODBC programming with Apache Derby or IBM Cloudscape as the backend data source. You’ll learn how ODBC applications differ from embedded SQL applications, how to set up Apache Derby as an ODBC data source, and how an ODBC application is structured. In a

(C.M. Saracco) It’s a common problem that often requires an uncommon solution: business analysts want integrated, Web-based access to critical corporate data. Sounds simple, right? Well it can be, if all this data is stored in a single relational database, such as IBM’s DB2 Universal Database (D

Q replication is a new, high-speed technology for moving transactions between DB2 databases. It’s a highlight of the just-released DB2 Information Integrator Version 8.2. One of the reasons Q replication is so fast is that it uses the powerful business integration product WebSphere MQ to zoom data a

(Susan L. Cline) ODBC support is available for the Cloudscape 10.0 GA and Derby databases as an IBM DB2 Run-Time client. This article discusses supported platforms, system requirements and information about where to download the free driver.

(Kevin Nilson) This subprocedure extracts data from a flat record (no dds), tab delimited, comma delimited, etc. It uses the field delimiting character and the positional number in the record to identify the desired data. So if I wanted to get the data from the ninth field of and EDI document, I wou

(Gautham Muthuravichandran) When you’re carrying out an database-intensive operations, like trying to insert a lot of records in one transaction or opening a bunch of connections at the same time, you run the risk of encountering various database configuration-related issues. Below are some of the f

(Susan Lawson) Up to now, we have discussed basic SELECT statements. The SELECT statement allows you to retrieve data from your database tables and assumes that data has been previously loaded into the tables. Now we will concentrate on manipulating data in tables using SQL. There are three main