Many times you’re required to write query to determine if a record exists. Typically you use this to determine whether to insert or update a records. Using the EXISTS keyword is a great way to accomplish this.
Other News
Log Navigator Passively Audits SQL Server Without Triggers
LockwoodTech has released version 1.0 of Log Navigator, a SQL Server auditing tool that leverages the SQL Server transaction log to passively audit data changes without triggers. As of 25 Sept 2003, the product is being offered at a special introductory price of $599 per developer. Upgrades and supp
Microsoft Says It’ll Get More Secure …. Again
By George V. Hulme – The company says it will reinforce its security efforts with better patch management, improved operating-system firewalls, and a security outreach program.
How To: View Transformed InfoPath Form Data in Internet Explorer
This article describes how to create an InfoPath form template and how to modify Template.xml. You must modify Template.xml in your form template so that the forms that you create with the template can be formatted to display correctly in Internet Explorer.
Questions Asked and Answered with Robert Catterall
We’re starting a new branch project built on Unix and WebSphere Application Server with WebSphere Business Components Composer (WSBCC). The project will produce 3,000,000 logs daily with 1,000 concurrent users, and the staff wants to put the logs on DB2 for OS/390. WSBCC uses JDBC and dynamic SQL. I
What Software is currently validated for DB2 for Linux?
For the latest release of DB2, DB2 UDB V8.1, only software that has been validated will be supported. We will continue to provide support for earlier DB2 UDB versions, as per the support statement issued at the time of their release. Information on what Linux distribution levels are validated can be
Oracle Eyes Linux on iSeries
by Seamus Quinn – When it comes to Oracle and the iSeries, you’d think that never the twain shall meet. The iSeries, after all, comes with its own venerable DB2/400 database, and IBM’s DB2 UDB continues to slug it out with Oracle in the wider enterprise IT arena.
Oracle Eyes Linux on iSeries
by Seamus Quinn – When it comes to Oracle and the iSeries, you’d think that never the twain shall meet. The iSeries, after all, comes with its own venerable DB2/400 database, and IBM’s DB2 UDB continues to slug it out with Oracle in the wider enterprise IT arena.
Book Excerpt: XForms Essentials
by Micah Dubinko – If you work with forms, HTML, or XML information, “XForms Essentials” will provide you with a much simpler route to more sophisticated interactions with users. This sample chapter discusses real-world examples, host language issues, linking attributes, and more.
Oracle Taking Laid-Back Approach to Piracy
By Mark Hachman – Oracle Corp. has a message for those obsessed with software piracy: relax.While most of the software industry has begun doggedly tracking down and stamping out instances of illegally copied software, Oracle’s top licensing executive said that her company will tolerate scatt