(Danna Nicholson) An IBM DB2 Universal Database (UDB) user-defined function allows you to build functions that meet your business needs. Learn how to use WebSphere Studio Application Developer to develop DB2 SQL user-defined functions.
Other News
MySQL and FirebirdSQL Top Open Source DB List
(Sean Michael Kerner) A new report out this week from Evans Data shows that FirebirdSQL and MySQL are the most popular open source databases currently in use.
Oracle Session Tracing Part V
(James Koopmann) Part five in our series will get closer to what we have, for years, experienced as Oracle’s tracing mechanism. Read on and get re-acquainted with creating trace files for TKPROF.
Reading an XML file from SQL Server
(Arthur Fuller) SQL Server 2000 makes it simple to export your data as XML; but importing XML and working with XML files are a little trickier. (R)
How to improve SQL Server security
(Barrie Sosinsky) There are several steps you can take to make SQL Server databases more resistant to tampering and hacking. Some are simply part of good server management, like keeping up with SQL Server’s latest patches, while others involve active-user monitoring. The five steps below will get yo
Web application searches: Powerful SQL tips
(Paul Holm) In a recent tip, I showed how to use a free WebSphere/Web utility called WOW to create Web applications using iSeries data. Hundreds downloaded the utility, and I was quickly overrun with questions such as, “Can I access my JDE files?” “Would it be feasible to build an order-monitoring a
JavaServer Faces interview: Ted Farrell and Adam Winer
(Miko Matsumura) Ted Farrell is chief architect for Application Development Tools at Oracle Corporation. Ted is responsible for the technical and strategic direction of Oracle’s development tools products, including JDeveloper 10g and the ADF framework. Ted has more than 15 years of experience build
DSN network library shown as ‘Other’ in ODBC Administrator
When creating a new SQL Server Data Source Name (DSN) using the ODBC API SQLConfigDataSource function, a network library must be specified. If the network library name is in lowercase letters, the Client Configuration dialog box may show it as “Other”.
Data Piracy: The Threat From Within
(Ken Richardson) Believe it or not, these are actual headlines from recent trade journals. And they contain a pattern – a frightening one: AOL Customer List Stolen, Sold to Spammer Acxiom Database Hacked Again IRS Computers Vulnerable, Report Says Offshore Outsourcing Poses Privacy P
Populating ASP.NET Form Validators from XML
(Robert Walling) ASP.NET form validators spelled the end of repetitive validation code. What used to take hours can now be accomplished in a matter of minutes using Visual Studio.NET’s drag-and-drop interface. ASP.NET form validators offer flexibility both in the types of validation they support and