(Serdar Yegulalp) Sometimes, a recordset will need to be returned with a non-standard sort order — something which isn’t possible with conventional sort or collation mechanisms. One example would be to have a zero in a numeric column placed at the bottom of the sort order, but to have everything el
Author: SSWUG Research
How to use DB2’s cross-reference files to help manage your database — Part II
(Ron Turull) In the first installment, I introduced you to the eight database cross-reference files that the AS/400-iSeries automatically maintains for the database files on your system. These eight files contain exhaustive information about each and every database file on your AS/400-iSeries. N
Oracle Database Clusters:What You Need to Know
(Michael Callahan and Kevin Closson) If you use or are considering Oracle9i or 10g RAC then don’t miss this Webcast. The speakers, leading authorities on shared data cluster technology, will show: How to fully optimize Oracle RAC for superior management, performance and availability. How to achieve
Installation Cookbooks: Deploying Forms on the Web
(Steve Callan) More and more, companies are making the move from the client-server model of Forms to the 9i/10g Application Server Web-based architecture. Previous articles in the Installation Cookbook series discussed how to install Developer Suite and Application Server. This article lays out a de
Get Your Stored Procedures Ready for Anything
(Drew Georgopulos) Permissions are restricted in most environments. Even in development environments, only members of the sysadmin and serveradmin fixed server roles can execute the sp_sdidebug and sp_addmessage extended procedures to grant use of SQL Server’s debugger and custom error messages, lea
Uncle Sam’s Semantic Web
(Paul Ford) What did the Semantic Web have to do with the war in Iraq? Not enough, says Jim Hendler, who heads the Mindswap Semantic Web research laboratory at the University of Maryland, speaking at the 2004 Semantic Technologies for e-Government Conference in McLean, Virg., held Sept. 8-9, 2004.
Get More out of SQL Server’s Web Assistant Wizard
(Ruben Heetebrij) The Wizard can take care of all the formatting and lead you through the creation of a Web page step by step. In addition, you can point SQL Server’s Web Assistant Wizard at the tables that contain the data you want to retrieve or monitor. Thus, query skills are not required eit
Programming With XMLBeans
(Abhinav Chopra) Get an in-depth look at the features and functionality of XMLBeans. This article introduces the technology with a simple example, takes you through the step-by-step process of compilation and binding, and discusses advanced features like XML cursors, tokens, and XQuery expressions.
How to Execute SQL Stored Procedures from Microsoft Access
(Danny Lesandrini) The simplicity and popularity of SQL Server means that more and more developers who build applications with Microsoft Access will want to learn how to take advantage of server side processing using SQL Server Stored Procedures. The following article will demonstrate a simple meth
Render PDF apps using DB2 XML Extender
(Naveen Balani) This tutorial shows developers how to render PDF applications using DB2 XML Extender, WebSphere Studio Application Developer (Application Developer) and the Apache Formatting Objects Processor (FOP) project. (R)