Oracle has announced Oracle Daily Business Intelligence for Compliance, an embedded compliance management reporting system for Oracle E-Business Suite.
Other News
Monitoring WebSphere Application Performance on z/OS
(Patrick Ryan, G Michael Connolly, Phil Anselm, Charles Neidigh, Raymond Sun, Theresa Tai and Michael Weintraub) This IBM Redbook was written for IBM zSeries users, performance analysts, system administrators and system engineers who need a comprehensive understanding of IBM WebSphere on z/OS perfor
Use DBMS_RANDOM to generate text and date values
(Bob Watkins) Numbers, text strings, and dates are three common datatypes used in tables. Although you would expect the PL/SQL package DBMS_RANDOM to be able to generate random numbers—and it does—it is also capable of generating random text and date values as well.
Generating change scripts in SQL Server 2005 Management Studio
(Arthur Fuller) In the typical dev environment, there is a development server, a functional testing server, a quality assurance server, and one or more production servers. Let’s suppose that your mandate is to modify a table on the development server, adding a column or changing a column’s name or d
ASP.NET 2.0 Crash case study: Unhandled exceptions
(Tess) For a long time all my case studies have been on 1.1. it’s time to venture out in 2.0 land and look at what may seem like a 2.0 specific issue.
Using Recursive Methods in Object-based PHP Applications
(Alejandro Gervasio) Welcome to the second tutorial of the series “Recursion in PHP.” Comprised of three parts, this series introduces the fundamentals of recursion in PHP, including the definition and use of recursive functions in procedural PHP scripts, as well as the creation of recursive methods
WebSphere Replication Server for z/OS Using Q Replication: High Availability Scenarios for the z/OS Platform
(Nagraj Alur, Steffen Herold, Huey Kim, Makiko Tsuchida and Mark Wiman) This redbook provides detailed instructions and scripts on managing failover and switchback in a WebSphere Replication Server for z/OS bidirectional Q replication environment for the z/OS platform. A typical business scenario is
Sharing Web Parts across multiple pages
(Damon Armstrong) Most Web Parts implementations allow users to create a single portal page where they can personalize the look, feel, functionality, and experience of their “My Home” page in an application. But what if you want to take Web Parts a step further and allow users to define a personaliz
DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2
(Carmen K. Wong and Stan Musker) Label-Based Access Control (LBAC) is a security feature introduced in the DB2® Viper release. With LBAC, administrators can control read and write access of a user at the table column and row level. This tutorial includes use case scenarios that demostrate how users
Compute Totals and Percentages
(Keshav Chennakeshav) Here is a tip to compute totals and percentages using the GROUPING and ROLLUP functions in summary queries. To get the correct percentage, the WHERE clause in the runtime table (designated with the alias “ts” below) should match the WHERE clause of the query. The output can be