(William Pearson) In past articles of this series, I presented ways of “extending” the data source tables underlying our Analysis Services 2000 cubes through the use of SQL expressions within the Member Key and Member Name columns (in the case of dimension structures), and in the Source column (in t
Other News
DB2 for z/OS Stored Procedures: Through the CALL and Beyond
(Paolo Bruni, Bhaskar Achanti, Suneel Konidala, Glenn McGeoch, Martin Packer, Peggy Rader, Suresh Sane, Bonni Taylor and Peter Wansch) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of applic
Informix Dynamic Server and Linux — Up and running
(Andreas Breitfeld) Find out how you can install one of the two major enterprise Linux distributions and configure it for running IBM Informix Dynamic Server (IDS) Version 10.0. You’ll learn how to get a trial version of the IDS database server up and running and how to use a disk as a raw device.
Tablespace Free (and more) Report
(Jayant Kulkarni) This script can be run on Oracle8i, Oracle9i and Oracle 10g databases to get a report/graph on tablespace free information, somewhat similar to the report from Oracle Enterprise Manager. The report provides a look at all the tablespaces in a database with information like “number o
Take Total Control Of Your Networking With .NET And UDP
(Yaniv Pessach) You’ve probably made use of Transmission Control Protocol (TCP) in your applications at some point, whether directly or indirectly—after all, HTTP runs on top of TCP, so every Web application is built atop it. But maybe you’ve wondered whether its brother User Datagram Protocol (UDP)
Q&A with David Webber, Co-chair of the ebXML Joint Marketing Team
(Benoît Marchal) To continue our ebXML series at developer.com, I had the chance to interview David Webber, a co-chair of the ebXML Joint Marketing Team. The interview was conducted via email. David is well known in the XML community for his long involvement with e-commerce. I originally met David a
Building web services with persistent state
(Alexandru Ghiondea) Because of the stateless nature of the HTTP protocol a web server considers every request as a new one. This means that, if you want to track a series of related calls, you must establish a way of identifying if the current request is a new request or is related to another reque
Oracle launches first visual database development tool
(China Martens) Oracle is set to make its visual SQL Developer tool generally available. Formerly known as Project Raptor, the free software will be Oracle’s first visual database development tool, according to company’s executives.
Custom Exceptions in VB 2005
(Josh Fitzgerald) Structured exception handling was introduced to Visual Basic programmers with the first .NET version of the language. Structured exception handling is important for two reasons: –It simply makes code more readable by using a syntax that is more congruent with the rest of the la
CodeSnip: Easy Data Encryption Using the DBMS Obfuscation Toolkit from Oracle
(Steven Swafford) Encryption and decryption is fairly common in many web applications today. If you are using an Oracle Database as your data store, then you can easily implement encryption and decryption at the database level using the DBMS Obfuscation Toolkit provided by Oracle.