(Peter-Paul Koch) On this page I import an XML document and then read out the data and put them in a table on the page. I think importing XML documents will become more and more important in the future. You can manage the XML document as a kind of database, while the HTML document contains all in
Author: SSWUG Research
RPG and DB2: The Future Is Now (Part II)
(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
Example of tracing under the DB2 Universal JDBC Driver
The following example shows a class for establishing a connection and gathering and displaying trace data under the DB2 Universal JDBC Driver. The class includes a method for the DriverManager interface and a method for the DataSource interface.
Tracing SQL in Oracle Database 10g
(Kimberly Floss)In a busy production environment with many active users, tracing a SQL session is time-consuming and complicated, because processing SQL statements in any multitier system that uses a connection pool can span multiple processes, or even different instances. With Oracle Database 1
Mixing It Up: Integrating Disparate Data in Web Applications
(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
Have a Nice Date
(Alexander Kozak) Not too long ago, one of our project managers asked me if there was a SQL Server function to return just the date–without the time portion. I knew the answer, of course, because of all the times I’ve coded T-SQL workarounds like this: SELECT sampleDate = CONVERT(VARCHAR(50), Da
Introduction to Device Independence
(Peter Mikhalenko) Several years ago the only way to work with a web site was through a personal computer. There were different browsers, some of which were text-based terminals and others that were GUI apps. It was assumed that the “normal” user had a machine with a large color display with full gr
INF: MDX: How to Determine the First or Last Member with Data
In some applications, it is useful to find the first or last dimension member that has data associated with it. This article illustrates how to use the HEAD(), TAIL(), and UNION() functions to return the first and last members of a dimension that have data. The article also illustrates the use of th
Trace File Manager: Managing Distributed Trace Files with Oracle and PHP
(Paul Gallagher) If you’re a DBA or a developer using Oracle-compliant tools, you almost certainly on occasion apply tracing to active database sessions, usually in the hunt for rogue SQL or some other coding misdemeanour.
ODBC programming using Apache Derby
(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