by MAK Muthusamy Anantha Kumar – Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date stamped file
Author: SSWUG Research
Ingres: A forgotten database, the untold story
By Phil Howard – Ingres (technically, Advantage Ingres Enterprise) is, arguably, the forgotten database. There used to be five major databases: Oracle, DB2, Sybase, Informix and Ingres. Then along came Microsoft and, if you listened to most press comment (or the lack of it), you would think that the
Dr. Edgar F. “Ted” Codd (1932-2003) Father of the RDBMS and a whole lot more
by Joe Celko – Obituaries come with old age — both the ones that I write and my own some day. Several years ago, I promised myself that I would try to meet people whom I admire before either of us died. Dr. Edgar Codd was one of my successes in that regard. By the time you read this column, […]
Maximizing the Value of Application Testing for DB2 on z/OS – OS/390
Are your resources being stretched even tighter from the demands of ever-growing test environments? Are you experiencing difficulties like too many testing subsystems, too much DASD used, overworked testing and DBA staff, unexpected hardware upgrades, corrupted test results, and lengthened developme
Compiling DB2 UDB Stored Procedures with GCC on Windows
By Jim Haungs – You can avoid a costly C compiler by using the solution outlined in this article, which relies on the GNU C Compiler (GCC), a free open-source C compiler, with DB2 on Windows®.
Transforming XML with PHP
by Bruno Pedro – This article compares two methods of transforming XML in PHP: PEAR’s XML_Transformer package and the W3C XML transformation language XSLT. I will first describe the PEAR project and its philosophy, with a focus on its XML transformation techniques. I will then give a brief introduct
Inserting CDATA Sections into XML Generated by DataSets
This demo shows how DataSet elements can be mapped to CDATA sections using a custom class named CDATAGenerator. Doing so helps to preserve data “as is” rather than converting some of it into entities.
Bring Scalable Vector Graphics to life with built-in animation elements
By Brian John Venn – Scalable Vector Graphics (SVG) is an XML-based language for drawing two-dimensional graphics. Sound dull? Far from it. SVG has many exciting features available to it such as transformations, alpha masks, filter effects, and animation. This tip provides working examples to show y
PL/SQL: What, when, and where
This is Chapter 1 from the O’Reilly book “Learning Oracle PL/SQL” by Bill Pribyl & Steven Feuerstein.
Using Oracle Locks to Manage Data Concurrency and Consistency
Ever wonder what prevents the same data from being modified by two or more users at the same time? Learn how Oracle manages data concurrency and consistency by using Locks.