(Craig Mullins) I have a query which selects from DEC fields and displays as follows: .00 100.00 I would like some formatting to display it as: .00 100.00 Is there any way of doing this? (R)
Other News
Performing Specific Tasks with DB2 and Approach
This document describes, step-by-step, how to access DB2 data through Lotus Approach 9.5.
Using an ADO.NET DataSet as a Reporting Services Data Source
(Christa Carpentiere) Learn how to build a data processing extension for Reporting Services that enables you to use an ADO.NET DataSet as a data source.
Did You Know? (A collection of tips and explanations)
(Hervé Deschamps) The Portlet Specification is at: http://jcp.org/en/jsr/detail?id=168. JSR 168. When registering a new provider with OracleAS Portal, only the user who registered the provider has privileges to see the provider portlets. If necessary, you can go to the Portlet Repository (Navigat
E-Business Suite boosts RFID, grid control
(Robert Westervelt) Oracle Corp. unveiled its E-Business Suite, targeting the business applications to specific industries such as healthcare and manufacturing, while boosting supply chain and enterprise grid management features. (R)
Use Delphi code to create/drop DB2 UDB database tables
(Bob Swart) This article examines the design and implementation of a Borland Delphi application you can use to create or delete/drop IBM DB2 Universal Database tables inside IBM DB2 databases. It provides several examples of sending SQL DDL to the DB2 DBMS using Delphi and the cross-platform dbExpre
OSQL Utility
(Don Schlichting) This article will explain and define the OSQL utilities ability to run scripts for administration and batch work when using Microsoft SQL Server.
Screenscraping the Senate
(Paul Ford) The United States government and the Semantic Web are a perfect match: imagine all of those senators and representatives, each query-able by age, party affiliation, bills proposed, committee membership, and voting record. For the last few years, I’ve wanted to collect as much data on the
Generating XML from Relational Database Tables
(Selim Mimaroglu) This article looks in detail at how to generate XML data from your relational database. Although the examples were run on Oracle, very little of the code is Oracle specific. You can easily use all the ideas and examples presented here in other relational databases. We did this proj
Waiting for Yukon
(Michael Otey) Competition in the database arena has never been fiercer. Remember the year 2000? Clinton was in the White House, the tech economy was booming, and Microsoft had just released SQL Server 2000. The new SQL Server release quickly broke through the wall from department-level to enter