(Ravinder Bahadur) Here is a simple way to provide a format for date fields in DB2. More complicated formating will need to use the to_char() function available on IBM’s web site. (R)
Other News
Cost-Driven Storage Schema Selection for XML
(Shihui Zheng, Ji-Rong Wen and Hongjun Lu) Various models and approaches have been proposed for mapping XML data into relational tables recently. Most of those approaches produce relational schema for given XML data, based on pre-defined rules, heuristics, and user specifications, without consider
Understand Oracle versioning: 8i through 11i.10
(Carol Francum) Listening in to a conversation between Oracle users can be very confusing: Imagine stepping into the break room and you hear Phil and Bill say, “We’re looking at migrating to 11i, we’re on 10.7 using 8.1.4.”
Working with DB2 Universal Database tables using ASP.NET Web Services written in Delphi 8 for .NET
(Bob Swart) This article shows how to extend an ASP.NET Web Service application to let clients update the database.
Using XML Catalogs with JAXP
(Tom White) XML documents often refer to other documents that an XML processor has to retrieve in order to make sense of the main document. These external resources, typically referred to by URIs, may be local files; or they may be remote, distributed across the web. In an ideal world the difference
MS Access for the Business Environment: Analyze and Report from the Windows Event Log, Part I
(William Pearson) This article continues the series, MS Access for the Business Environment. The primary focus of this series is an examination of business uses for the MS Access relational database management system. The series is designed to provide guidance in the practical application of data an
Find the Number of Days
(Sidhartha Upadhyay) Use this function to find the number of days between two given dates.
FIX: Using an IP Address for OLAP Data Source Connection Property Causes Error
When making a connection to an OLAP data source and specifying an IP address for the Data Source property in an ADO or ADO*MD connection string, the following error occurs: Microsoft(r) OLE DB Provider for OLAP Services error ‘80004005’ Cannot connect to cube file, ‘IP address’ , file may be in
Securing Your Database
(Michael Dougherty) Information security is a critical element of business operations. Yet, surprisingly few organizations have integrated security policies, measures, and technologies to protect their information assets against internal and external threats. Billions of dollars’ worth of productivi
Matters of Syntax – ConciseXML builds upon the important qualities of XML and S-Expressions
(Mike Plusch) XML originated with the document-markup world of SGML and has become the leading syntax of the Internet. Its use has been for documents and data – not for programming logic. S-Expressions, or symbolic expressions, is the syntax behind Lisp-like languages, including Scheme. Basicall