(Mads Kristensen) During the years I’ve seen a lot of different ways of commenting code – some good and some bad.
Other News
Altering Oracle’s Value Returned for SYSDATE
(James F. Koopmann) If you have ever tried to do testing for applications that was time sensitive and thought you had to change the operating system time to change the date and time, try this method.
How to build an Oracle Forms application on BPEL/WF
(Andre Crone) Old style Forms applications normally don’t hold much workflow functionality. Sure there is an order in which the forms should be used. The workflow of the application is in the mind and knowledge of the user. For my current project I am investigating, together with my colleague Peter
Use XML in DB2 SQL stored procedures
(Rex Oliva) IBM DB2 9 for Linux, UNIX, and Windows adds major new XML functionality over and above prior DB2 releases. Before DB2 9, you could either store XML documents as LOBs or shred incoming XML data into relational tables, a process which required an add-on tool called XML Extender. However, D
Interview with Andrey ‘Poohie’ Hristov, Developer at MySQL AB
(Lenz Grimmer) One of the new features in upcoming MySQL 5.1 Server will be the Event Scheduler. This feature was implemented by Andrey Hristov within the scope of a master’s thesis for the University of Applied Sciences in Stuttgart. We incorporated his contribution into our code base – you can rea
Advanced topics for DB2 Data Warehouse Edition users, Part 1: Crash recovery utility for DB2 Data Warehouse Edition SQL Warehousing Tool
(Cheung-Yuk Wu and Marion Behnen) Protect your data warehouse environment using a new, downloadable crash recovery utility. With this tool, perform health checks and recover any inconsistent IBM DB2 Data Warehouse Edition SQL Warehousing runtime metadata caused by unhandled interrupts. After the too
Some thoughts on Declared Global Temporary Tables from Pat Bossman
(Willie Favero) Pat Bossman, DB2 for z/OS Query Optimizer Team at IBM’s Silicon Valley Lab (SVL), was nice enough to share with me an internal blog entry he recently wrote on Declared Global Temporary Tables and told me I could in turn share it with you all. So, since I cannot use a link to point yo
Introducing Regular Expressions (Part 1)
(Peter Aitken) It’s usually considered a complement to say that someone is a regular guy, but what about a regular expression? Yep, they’re good too, way cool. OK, they’re not really cool, but they are very useful! In a nutshell, a regular expression (sometimes called regexp or regex) is a template
An alternative way to MSWord Render extension of SQL Reporting Service using XSLT and xml document mapping
(n_ahid) SQL Reporting service doesn’t support export report to MSWord yet. By using render extensions for exporting MSWord not so easy. This article describes export report to MSWord doc file has some data before. Basically some client/end users always prefer adhoc reporting and some time prefer ba
Exception Handling in .NET 2.0
(Uday Denduluri) Exceptions are unusual error conditions that occur during execution of a program or an application. Most of the programmers concentrate more towards the core functionality and, hence, handling of the exceptions is neglected. It is commonly observed practice that placing a try and ca