(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) Transfer of control statements are used to specifically tell the SQL procedure where to continue execution. This unconditional branching can be used to cause the flow of control to jump from one poi
Other News
DB2 version 8 certification: Everything you need to know
(Howard Fosdick) Certification has arrived, no question. But as a DB2 professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? That last thought is key — knowing the inside story on DB2 certification before you proceed will
Writing and Executing Your First Yukon CLR Procedure
(Suhil Srinivas) This article explains the various steps involved in writing and executing a Yukon CLR Procedure. This article also is a starting point to develop complex data crunching SQL procedures.
Fast Reporting from LogMiner
(Jutay Medeiros) This procedure generates a report and, if you want, an UNDO script using LogMiner (for Oracle8i and Oracle9i). I think that I can improve this procedure, but this is the first step. I hope all of you enjoy this procedure. Note: You must define the UTL_FILE_DIR parameter before runni
List Available DBCC Commands
DBCC Commands or Database Consistency Checker commands have been with SQL Server from its early ages itself. In this article we would list the available DBCC commands listed using the DBCC Help command. Many in this list are undocumented and are rarely used in practical scenarios. But these form th
Afraid of Commitment? The Impact of Uncommitted Read on Application Performance
(John Lynch and Yong Ju Li) Recently we decided to evaluate the impact of changing our DB2 Connect software from Cursor Stability (CS) to Uncommitted Read (UR) for ERwin-our database modeling tool. Using the ERwin tool we ran a before and after comparison of the two settings and came back with an in
XML Data in SQL Server
(Mike Gunderloy) If you’ve been working with SQL Server 2000, you’re probably already familiar with the XML capabilities provided by the SQLXML technologies, a set of add-on libraries for SQL Server. With SQLXML installed, you can return the results of relational queries as XML fragments, use XPath
Can I store my XSL in a stored procedure?
This is kind of an interesting question that I had some fun with. The answer is yes you can store your XSL stylesheet in a stored procedure. This may have some value in that you can manage both your XML output and your XSL stylesheets in one place. This first example is more of an interesting me
Migrating Express Applications To Oracle 9i
(Mark Rittman) Oracle Express has for many years been the industry’s leading OLAP server, offering unparalleled functionality, query performance and application support. With Oracle 9i, Oracle has taken the best features of Oracle Express and embedded them in the database kernel. By moving to Or
DB2 Instance and Fast Communication Manager – Part 2
(Marin Komadina) In the last article, we discovered the DB2 instance memory structure and fast communication manager, together with all of the DBM parameters influencing memory utilization. In this article we we will continue along those lines with an inside view of FCM tuning and troubleshooting te