(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
Author: SSWUG Research
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
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
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
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.
XML Code Comments: What, Why And How
(Mads Kristensen) During the years I’ve seen a lot of different ways of commenting code – some good and some bad.
Stored procedures: Balance network loads — part 1
(Ron Turull) SQL (Structured Query Language) stored procedures are a great feature. They provide an excellent tool to help optimize client/server applications. By shifting key portions of the processing onto the server, network data flows can be reduced substantially. All this without bogging down t
Loading XSLT stylesheets embedded into an assembly – the right way
(Oleg Tkachenko) Everybody knows that XSLT stylesheet can be embedded into an assembly by setting in Visual Studio its “BuildAction” property to “Embedded Resource”. Such stylesheet then can be loaded using Assembly.GetManifestResourceStream() method.
How to Use Oracle Java XQuery API
(Anghel Leonard) This code outlines the main steps involved in using the Oracle Java XQuery API (OJXQI). If you are familiar with the DataDirectXQuery – XQuery for Java (DDXQ-XQJ), you may notice a some similarities.
Using PL/SQL Associative Arrays
(Mark A. Williams) Suppose you’ve just received an e-mail detailing several IT initiatives, two of which will affect your future application development techniques. First, all applications should be designed to minimize network utilization. And second, applications that use Oracle databases must use