(Mike Faust) In V5R3, IBM enhanced DB2 UDB implementation of SQL by adding 25 new BIFs. In Part 1 of this series, we explored new functions used for data partitioning. In Part 2, we’ll explore six new data encryption functions that allow us to make our data more secure.
Other News
Visual Basic.NET 2005
(Amirthalingam Prasanna) Although Microsoft.NET languages have more or less the same facilities and power, one must be aware of the syntax and capabilities of a language to take full advantage of it. This article introduces new features of the upcoming Visual Basic.NET language that is part of Visua
Which distributed edition of DB2 Version 8 is right for you?
(Paul Zikopoulos) This popular article is updated with the latest news in product features, editions, and licensing for Version 8.2.2. The author lays out the options and includes a quick reference that maps typical user environments to the suggested DB2 edition.
First Steps with Java Struts
(John Topley) Just over a year ago, I started to learn how to use the Jakarta Struts J2EE Web application framework. During this journey, I realised that I found some aspects of Struts confusing at first, and that many other developers might well suffer the same difficulties. This article is an atte
Debunking XQuery myths and misunderstandings
(Frank Cohen) XQuery shows much promise for software architects and developers because it greatly reduces the amount of code you need to write to build services that work with XML. You might think XQuery does everything and is well understood, but misconceptions and misunderstandings still exist in
The Sorcerer of OO, Part 1
(Lewis R Cunningham) I could have called this OO In Oracle: A Techie’s View. But the Sorcerer of OO is a much cooler title. 😉 You have to pronounce OO as ooh! as in Ooh and Aah!
FIX: You may experience unexpected delays in query execution and unexpected time-out situations, and you may receive error message 17883 when you use the BULK INSERT command in SQL Server 2000
When you use the Transact-SQL BULK INSERT command in Microsoft SQL Server 2000, you may experience one or more of the following symptoms: • You may experience unexpected delays in query execution. • You may experience unexpected time-out situations. • You may receive error message 17883 in t
Calling a stored procedure from ASP.Net
(Brad Kingsley) I guess I’m from the “old school” because I learned coding without a fancy GUI and I still have a tendency to lean that direction when possible. The latest version of Visual Studio is a great tool, but I still like to understand what’s going on rather than just dragging and dropp
Convert Between VB.NET and C#
(Dave Doknjas) VB.NET and C# are so similar in expressive power and features that conversion between the two at first glance appears to be little more than adding or removing semicolons and curly braces. In fact, there are substantial differences between the two languages that you should be aware of
Big Lists in Small Spaces
(Fabio Arciniegas A.) Many interfaces on the web are just lists of elements. You click one, and you are taken to a subsequent “card” page with the properties of the item. Simple enough, right? Well…not always. While this approach works for web pages on your 21-inch monitor, it is less effective on