(Susan Sales Harkins, Arthur Fuller) Globally unique identifiers (GUIDs) distinguish hardware, software, and users. Originally, Microsoft designed the GUID value for use with ActiveX controls; Windows uses a 128-bit GUID to identify ActiveX controls. A 48-bit version generates an Ethernet adapter ad
Author: SSWUG Research
BMC brings SmartDBA to the mainframe
(James Niccolai) BMC Software Inc. will soon release the first of its SmartDBA tools for IBM Corp.’s DB2 mainframe database, marking what it called a significant milestone in its effort to provide a single console for managing mixed database environments.
Using Java with DB2 for OS/390
(Craig S. Mullins) Just about everyone has at least heard of Java and how it is going transform the world of IT. But just because you’ve heard about Java doesn’t mean you fully understand it. And even if you know a bit about Java, there is always more to discover. Let’s face it, there’s a lot of hyp
Get the most from ContentHandlers
by Brett McLaughlin – This tip breaks down each method in the org.xml.sax.ContentHandler interface, explaining the purpose and usage of each callback, and its relation to an XML parsing event. You will understand the arguments to each method, and the information passed from a SAX parser to its regis
DocBook XSL: The Complete Guide – now in paperback
The second edition of Bob Stayton’s DocBook XSL: The Complete Guide, covering “all aspects of DocBook XML publishing tools, including installing, using, and customizing the XSL stylesheets and processing tools”, is now available in paperback book form.
.NET tools to be bundled in next SQL Server
By Margie Semilof – After two decades with the same underlying technology, SQL Server is in need of a facelift, Microsoft says. At the Professional Developers Conference, Microsoft vice president Gordon Mangione revealed some early features of Yukon, the next version of the database management syste
XQuery: A Guided Tour
XQuery is not only a query language, but also a language that can do fairly general processing of XML. It is a strongly typed language that works well with data that may be strongly or weakly typed. Because the types used in XQuery are the same types used in XML and XML Schema, the type system is a
More Trees & Hierarchies in SQL
(Rob Volk) Hierarchies are sometimes difficult to store in SQL tables…things like trees, threaded forums, org charts and the like…and it’s usually even harder to retrieve the hierarchy once you do store it. Here’s a method that’s easy to understand and maintain, and gives you the full hierarchy
Simulating Oracle Sequences in Microsoft SQL Server & ColdFusion
(James Thornton) The problem with using identity columns as primary keys for Web development is that identities are generated at the time of insert, and you can’t pull them into your application code prior to inserting the row. This means that a user could double click the submit button resulting in
Compiling DB2 UDB Stored Procedures with GCC on Windows
(Jim Haungs) Historically, using stored procedures in DB2 has required a separately installed (and sometimes costly) C compiler. The solution outlined in this document describes how to install and use the GNU C Compiler (GCC), a free open-source C compiler.