(Frank Nimphius) ADF Faces RC components provide a element that you can use to allow users to export table data into an Excel format. The good news with this also is that it goes with no line of code that needs to be written.
Other News
Oracle BI EE 10.1.3.2/3 – Dual Table Equivalence
(Venkatakrishnan J) I had received a couple of emails on how to have a table equivalent to DUAL(of Oracle Database) in BI EE. One of the major advantages of the Dual table in an Oracle Database is that you can supply some values in a select statement and the dual table will print it out for you(of c
SQL Server Triage – Lessons Learned
Featured Article(s) Removing Oracle Database Passwords from Unix Shell Scripts Oracle Password Repository (OPR) is a small program that can be used to allow you to replace hard coded passwords in shell scripts. More Than 30 Technical Sessions, On Your Computer …no travel required to get up to speed and confident with SQL Server. We’ll be covering everything from Backup […]
Top 10 List for SQL Server – Need Your Input
Featured Article(s) Find out the last updated date of SP, UDF, Views, Triggers in SQL Server 2005 (Vadivel Mohanakrishnan) This article explains the way to list the last updated datetime of Stored procs, user defined functions, views and triggers in SQL Server 2005. Watch SSWUGtv The following are available now: [Watch] – SelectViews SQL Server Show – Microsoft interviews, features […]
MySQL – SQL Injection Prevention
If you have ever taken raw user input and inserted it into a MySQL database there’s a chance that you have left yourself wide open for a security issue known as SQL Injection. This lesson will teach you how to help prevent this from happening and help you secure your scripts and MySQL statements.
.NET Language-Integrated Query for XML Data
(Michael Champion) LINQ to XML was developed with Language-Integrated Query over XML in mind and takes advantage of standard query operators and adds query extensions specific to XML. The samples in most of this document are shown in C# for brevity.
Tips for Copying Catalog Statistics from Production to Test Subsystems
(Billy Sundarrajan) Application developers and database administrators often face challenges with differing access paths in Production and Test DB2 subsystems when performing an EXPLAIN for a given SQL. In most installations, tables in Test subsystems are a lot smaller than the ones in Production su
Manipulate XML Content the Ximple Way
(Jimmy Zhang) The latest Java version of the Virtual Token Descriptor for XML (VTD-XML) can function as a slicer, an editor, and an incremental modifier to intelligently manipulate XML document content. This article will show you how to use it, introduce you to the concept of “document-centric” XML
Revisit DB2 9 index last used catalog column
(Willie Favero) This morning I listened in on Phil Grainger’s DB2 9 webcast (“DB2 9 for z/OS Pre-Reqs, Migrations, Deprecations”) and it reminded me of something that has always bothered me about blogging. You blog in the “today”. A blog is very much like have a conversation with someone. Most peopl
Managing DB2 for i5/OS schemas and journals
(Kent Milligan) Many System i developers are starting to use SQL to create their database objects instead of the proprietary non-SQL interfaces. This article will show you how to use a schema with IBM DB2 for i5/OS to group related database objects. DB2 for i5/OS was previously named DB2 UDB for iSe