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.
Other News
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
Import XML Document
(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
Sample Application: XML Form Generator, Part 1: Generating an XML Form
(Andrew Mooney) One of the most frequent tasks that web developers receive is that of creating a form to collect user input. One solution is to use an ASP.NET web page to create an XML file that will be used as the basis for a Web form. The three part article, XML Form Generator, will demonstrate ho
Improve Your Scripting with the test Command
(Emmett Dulaney) Underlying every conditional statement is a test to see what is true and what is not. Knowing how this works can make the difference between writing mediocre scripts and ones you’ll be proud of.
Phillips Sounds Off On Oracle Midmarket App Offensive
(Barbara Darrow and Steven Burke) Oracle President Chuck Phillips spoke with CRN Industry about Oracle’s midmarket application offensive and the launch of its E-Business Suite Special Edition North America, which will be sold exclusively through select partners.
MDX in Analysis Services: Mastering Time: Moving Averages – Another Approach
(William Pearson) In this article, we return to the subject of the previous article in the series, Mastering Time: Introduction to Moving Averages, and examine another approach for achieving “rolling average” aggregations. As we learned in our last article, “rolling,” or “moving,” averages, form
PRB: How to Generate a Snapshot of a Published Table and Apply It to the Subscribers
SQL Server 2000 enables replication of declared referential integrity (DRI) to Subscribers through the initial snapshot. The addition of this feature represents a significant performance enhancement for SQL Server 2000 as compared to other versions, but may cause unexpected results when the snapshot
Java SDKs for DB2 Development Center on OS/390 and z/OS
(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
IDENTITY() Function Isn’t Reliable for Imposing Order on a Result Set
(Brian Moran) T-SQL is a powerful tool, but it doesn’t provide native language constructs to do all the operations you need to do, such as creating rank within a result set. I’m not going to describe how to impose order within a result set (read Itzik Ben-Gan’s T-SQL 2005 column “Ranking Functio