This step-by-step article describes how to move a database diagram that was created in SQL Server Enterprise Manager. Database diagrams are contained in the dtproperties system table of the database.
Author: SSWUG Research
Troubleshooting the Forms Listener Servlet
The purpose of this document is to give an insight into how the Forms Listener Servlet can aid in the diagnosis and detection of various anomalies and errors commonly seen in a web deployed Oracle Application Server 10g Forms application. The paper discusses which files contain diagnostic informatio
Optimizing DB2 for z/OS Catalog Usage
(Craig S. Mullins) This complimentary 6-part eCourse will provide you with expert tips and techniques for optimizing DB2 for z/OS catalog usage. The Lesson Plan includes: Lesson 1: Use RUNSTATS on the Catalog Lesson 2: REORG the DB2 Catalog Lesson 3: More Catalog REORG Scenarios Lesson 4: C
A Cure for Madness
(C.J. Date) I wrote this short note in response to a paper titled Subquery Madness, in which the author, Jonathan Gennick, raises a question about subqueries in SQL and their implementation in Oracle. The following is an edited version of his question. We’re given a table called SUBTEST with t
How To Include Client-Side Script Functions in an XSL Document
When you return HTML from an XML/XSL transform, you often have to return SCRIPT blocks. This article describes how you can include the DEFER attribute for the tag when you include a script function in an XSL document that is used in a client-side XML/XSL transform.
Validating Input Xml Data Files
(Susan Abraham) In most Business Applications we frequently find that the input to a System would be in the form of Xml Data Files. This is particularly true with Modules of a Project that deal with Interoperability. These input files would require to be validated. The validation of an Xml input Fil
.NET and DB2 UDB
(Victor Alvarez) With the latest release of DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows, IBM provides .NET developers with a credible alternative to SQL Server. Traditionally, developers working with .NET have resorted to Microsoft SQL Server as the database of choice.
Sending Query Analyzer Results to Excel
(Brian Moran) I often send query results to users through email or copy the results to Microsoft Word documents. Query Analyzer in text mode provides headings for the query results, but the headings don’t copy and display well in Microsoft Excel or email. I can use Query Analyzer’s output-file optio
Controlling Mythological Code
(Steven Feuerstein) Don’t use the XYZ feature; there was a problem back in version n.n.” “Always use explicit cursors; doing so is the most efficient way to fetch a single row of data.” “Avoid packages; they use too much memory.” I bet you’ve heard one variation or another of such statements
Build a .NET Application on the Oracle Database
(John Paul Cook) In this article, I’ll explain the basic yet essential processes involved in building a .NET application that uses an Oracle database, including: –How to add project references to support Oracle class libraries in your .NET project –How to create Oracle Database connection