(Girija Parmeshwar) The DB2 Version 9 Developer Workbench (DWB) gives you a way to easily create variations of SQL and SQLJ stored procedure packages from the Database Explorer, on a DB2 for z/OS server. DWB displays all the packages associated with a stored procedure under a package folder for
Author: SSWUG Research
Music and the semantic web
(Chris Mitchell) The semantic web has had some great claims made about it. With the recent advent of some c# class libraries that work with its various layers it becomes easy to explore this ‘greatness’ practically and make up your own mind. One good application, is to illustrate the effect the sema
Build a Low Overhead Test Bed for Your JDBC Code
(Kulvir Singh Bhogal) There’s a good chance that your enterprise applications interact with a database. Testing your application code against a database is important in making sure that your application works as expected. And while there are certainly plenty of ways to undertake that kind of testing
Finding Data – SQL WHERE Clause
(James F. Koopmann) We do not always want to SELECT everything from a table. The matter of finding the information required is a function of implementing the optional WHERE clause of the SELECT statement.
Restoring from previous SQL Server versions
(Greg Robidoux) With several SQL Server versions in use — 4.2, 6.0, 6.5, 7.0, 2000 and now 2005 — you will likely need to restore databases from a previous version to a later version. (R)
Composite Transact-SQL Constructs: Batches, Scripts, and Transactions
(Dejan Sunderic) Transact-SQL (T-SQL) statements can be grouped and executed together in a variety of ways. They can be –Compiled as a part of a stored procedure, user-defined function, or trigger –Written and executed individually or in groups from client utilities in the form of batche
Guide to Advanced Linux Command Mastery
(Arup Nanda) In Sheryl Calish’s excellent article “Guide to Linux File Command Mastery,” you learned some routine Linux commands, which are especially valuable for Linux newbies. But now that you have mastered the basics, let’s move on to some more sophisticated commands that you will find extremely
How Do I… create an XML document from undefined legacy data?
(Edmond Woychowsky) Nebulous is a great word, not only is it fun to say, it is also useful in describing the requirements for a project that I worked on recently. The requirements went something like this; take a flat file, that was produced by an upstream mainframe application and produce an XML do
Caching part 1
(Abey George) Caching is a technique which is used to increase performance by decreasing access times for obtaining data. This is accomplished by retaining the frequently accessed data in memory. This technique is used by many operating system and databases to cut down on the no of times the data is
VoiceXML 2.1
(Jeff Kusnitz) VoiceXML 2.1 was never intended to be a replacement for VoiceXML 2.0. The intent was that it include a small number of features that were not included in VoiceXML 2.0, but were deemed significant enough to warrant documenting and standardizing. VoiceXML 2.1 has met these goals — it c