(Ajay Gursahani) This article gives a brief understanding about External tables. External Tables are defined as tables that do not reside in the database, and can be in any format for which an access driver is provided. This external table definition can be thought of as a view that allows running a
Author: SSWUG Research
Oracle SQL tricks Part 1
Here are some useful SQL tricks, tested on an Oracle database. The tips include information on derived tables, locking, working with random numbers, and more.
Integrate xmlspy 2004 Into VS.NET
(Dan Wahlin) Altova’s xmlspy has been one of the top XML editors for several years due to its support for XML document editing, schema design and validation, XSLT editing and debugging, and WSDL/SOAP capabilities. I’ve been a fan of xmlspy, but have often wished there were a way to integrate it
Daydream Software plays to win with DB2
Whether you are flying your air-car through Cairo trying to pick up different colored balls faster than your opponent can, or racing a ski mobile over picturesque snowscapes, vying for video game dominance can be tough. Still, it’s nowhere near as intense as the rivalry among the video game companie
INF: Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2
This article provides a sample SQL script for creating a linked server to DB2 using sp_addlinkedserver, and issues a few queries to illustrate the Distributed Query Processing (DQP) using DB2OLEDB, the Microsoft OLE DB provider for DB2. Please refer to the following article in the Microsoft Knowledg
Migrating to .Net
(Godfrey Baker) Microsoft’s .Net initiative is widely regarded as the “next big thing” for distributed application development. The promise for Web development is clear: faster development, less custom coding, and increased stability. But what is required to migrate current applications to the new p
Connecting with Oracle: Finding and Setting a Configuration File Location
(Steve Callan) Last month’s “Connecting with Oracle” article dealt with properly configuring the tnsnames.ora file. Using a statistics-related analogy for a minute, you can have Type I and Type II errors with respect to your tnsnames.ora file. You can have a “good” tnsnames.ora file, but “reject” it
Anticipating Primary Key Violations
(Karen Gayda) Years ago when I was just breaking into the programming field I worked with Paradox databases. While Paradox pales in comparison to a database engine like SQL Server, it did have one interesting feature that has not yet been duplicated by Microsoft. When performing an insert into a tab
HOW TO: Use XML templates to edit/view data using HTML forms
This example will demonstrate how to use XML for SQL to view and edit data in a browser. The example makes use of an XML template and an XSL stylesheet. It can be run using the sample Northwind database.
Can One Size Fit All?
(Dare Obasanjo) Traditionally, APIs for processing XML have been categorized according to whether they’re designed for processing entire XML documents loaded in memory, such as the W3C DOM, or for processing XML in a streaming, forward-only fashion, such as SAX. However, these divisions do not fully