Here are some more useful SQL tricks, tested on an Oracle database. Tips on building a test table and inserting values automatically, data types, insert/update with the check option and more.
Author: SSWUG Research
Building a House of Standards
(Brian Travis and Mae Ozkan) The main goals of web services are three-fold: –Get programs talking to each other, because we want to leverage the existing technology. –Be cheap, compact and scalable for all parties, because we want to have web services everywhere, providing services to everyon
Oracle: Preventing Corruption Before it’s Too Late – Part 2
(Marin Komadina) One block is soft corrupted when a block format is different from the Oracle default block format. Oracle soft data corruption (logical, software) is usually detected while reading some data from the disk to the database buffer cache. In the buffer cache, Oracle kernel investigate b
Using the PARSENAME function to split delimited data
PARSENAME is an SQL Server function used for working with linked servers and replication. It is also a handy addition to your TSQL toolkit when writing queries involving delimited data. This article covers the standard usage of PARSENAME as well as some handy tricks from a real world scenario.
Uniquely Trigger Happy
(Dave Hauser) Trying to get around the 255-byte index key limit without sacrificing uniqueness? Triggers just might save the day. If you’ve ever had to adapt schemas from other platforms — such as DB2 Universal Database (DB2 UDB) for NT — to DB2 UDB for z/OS and OS/390 you’ve probably bumped up a
Follow these steps to secure your data layer
(Robert W. McLaws) For many developers, building applications is a lot like building a family. The Business tier is like the oldest child: mature and responsible, it knows how to handle everything, and is good at telling people what to do. The Presentation tier is like the youngest child. The baby o
How To: Configuring SQLXML IIS
(Dan Doris) As a note, most problems I’ve seen with people setting up a virtual directory in SQLXML, tends to be from either using the normal IIS snap-in instead of the SQLXML IIS Configuration utility or the standard IIS setup has been changed. Prior to setting up SQLXML you should verify your IIS
DB2 Stored Procedures Go Mainstream
(Robert Catterall) DB2 shops are finally diving in with this underused feature. When support for stored procedures first appeared on the mainframe scene with DB2 for OS/390 version 4, it wasn’t an instant hit. For one thing, the feature was aimed at users of the DB2 for OS/390 distributed data fa
Walkthrough: Accessing an XML Web Service Using Managed Extensions for C++
The following walkthrough describes the process for accessing an XML Web service from an application created using the Managed Extensions for C++. During the course of this walkthrough, you will accomplish the following activities: –Create a client application using the Console Application
The Downside of Oracle CRM
(Erika Morphy) In the first article in this two-part series, we took a look at what analysts and customers have identified as PeopleSoft CRM’s greatest weaknesses — a list that runs the gamut from poor navigation to a confusing approach to the company’s CRM philosophy. Now it is Oracle’s turn t