(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip)Conditional statements allow stored procedures to make decisions. They are used to define multiple branches of execution based on whether or not a condition was met.
Author: SSWUG Research
RDF Roundup
(Edd Dumbill) With the exception of a not unfamiliar round of bile spilling about SOAP and web services, recent weeks have been quiet in the XML developer community. Those eager futurists from the RDF interest list have kept going, however, and an overview of that activity forms the core of my repor
Part 1: Tuning Informix SQL
(Jianing Fan) SQL queries provide the backbone for Informix database applications. This article discusses guidelines for SQL query tuning for Informix, looks at factors you need to consider when tuning SQL queries, and examines some real life tuning examples gathered from the author’s experience
INF: How To Perform Time Series Calculations
Time series calculations are frequently required in business and financial reports. Multidimensional expressions (MDX) provide the following time oriented functions to perform time series calculations: –YTD –QTD –MTD –WTD –LastPeriods –PeriodsToDate This article describes how to us
Making Package Magic
(Kirk Haselden) Microsoft has completely rewritten Data Transformation Services (DTS) in SQL Server 2005 for many reasons. In addition to streamlining DTS’s functionality and making it easier to use, the rewrite improves scalability and performance. In “What’s New In DTS?” (May 2004, InstantDoc ID 4
Structured Query Language (SQL) : A Practical Introduction (Free book)
(Akeel I Din) The Structured Query Language, SQL is a query language which is used with relational databases. This chapter starts by describing some of the terms used in data processing and how they relate to SQL. The later part of this chapter describes relational databases and how SQL is used to q
IBM Software Development Technical Conference
Join us in Strasbourg, France on October 12-15, 2004 for the brand new Software Development Technical Conference. This new conference offers you the chance to gain a full and deep understanding of the software development world and how your organisation can meet your customers’ requirements. In
The Oracle 10g Scheduler, Part 2: Implementation
(Jim Czuprynski) Oracle 10g’s new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the second in a series – provides practical examples of using the Oracle Scheduler’s new functionalities, including a discussion of transitioning from
IBM uncorks Masala special brew
(Ed Scannell and Cathleen Moore) This week, IBM will deliver its long awaited DB2 Information Integrator, codenamed Masala, whose sophisticated search engine will let corporate users dig out and analyse data across a heterogeneous range of information data stores.
HOWTO: Programming for Oracle on Linux, Part I
(Ryan Ordway) By far, the most common RDBMS platforms for Linux-based systems are MySQL and PostgreSQL, due to their inclusion in most major Linux distributions. Quite a few shops still run legacy databases, however, using commercial database servers such as Sybase or Oracle. Even Linux Journal gave