(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce
Other News
Use date functions in the XSLT Standard Library
(Brian Schaffner) The XSLT-SL project provides a rich set of functions that you can use within your XSL stylesheets. These functions include string manipulation, node processing, URI processing, and date functions. This article looks at some of the date functions and how you can use them in your sty
Leverage your Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8
(Raul F. Chong) In the world of information technology today, we are constantly bombarded with new information — new software products, new versions, new features. Leveraging your current knowledge is one way to keep up with this constant change. This article shows you how you can use your cur
Servlets and JSP Step Up
(Budi Kurniawan) The upcoming J2EE 1.4 includes the new Servlet 2.4 and JavaServer Pages (JSP) 2.0 technologies for Web application development in Java. This article offers a look at the new features in both specifications and provides sample code for each feature where appropriate. The article assu
Basic and complex SQL joins made easy
When you perform an INNER JOIN, only rows that match up are returned. Any time a row from either table doesn’t have corresponding values from the other table, it is disregarded. Because stray rows aren’t included, you don’t have any of the “left” and “right” nonsense to deal with and the order in wh
XQuery Language Expressions
(Kurt Cagle) When you combine XML, which is essentially an open data format independent of any specific data-formatting language, with a universal addressing mechanism such as URLs, great things happen. These two factors together make the endpoints of a transaction transparent to the kind of technol
Exploring SQL Server Triggers
(John Papa) Triggers are one of the core tools available in relational databases such as SQL Server™ 2000. As one of the mainstays of SQL Server database programming, triggers also happen to be one of the topics that I get most of the questions about. In this month’s installment of Data Points, I wi
How to expose CORBA object as JAX-RPC Web Service
The Java API for XML-based remote procedure calls (JAX-RPC) provides standard way of building portable and interoperable SOAP based Web Services. It simplifies the process of building Web services that incorporate XML-based RPC. In JAX-RPC, a remote procedure call is represented by an XML-based prot
Using TIMESTAMP Columns Versus DATE and TIME Columns
(Craig S. Mullins) A frequent requirement of applications is to store date and time information in the of a DB2 table. The date and time data may be required for any number of reasons, such as: –To record the date and time the row was added to the table –To act as the primary key for the row
SQL users: Microsoft must do more on security
(Marc L. Songini) Microsoft Corp appears to be trying to make the security of its SQL Server database more watertight, but it still has a ways to go, according to users. That was the message from SQL Server database administrators here at the Professional Association for SQL Server Community Sum