This article demonstrates how to use two different methods using SQL Distributed Management Objects (DMO) to return dates formatted to a specific regional locale. By default, the date format for SQL server is in U.S. date format MM/DD/YY, unless a localized version of SQL Server has been installe
Other News
ColdFusion with Oracle – Tips and tricks
This article includes some great tips that can help in your development of applications with ColdFusion working against Oracle.
TechTip: V5R2 Atomic Stored Procedure Change
(Kent Milligan) Before V5R2, SQL stored procedures that contained atomic compound-statements automatically issued a Rollback statement if the procedure encountered any errors during execution and a Commit statement if the procedure executed successfully. For example, if the Delete statement fail
Using C#Builder Architect to build model-driven Windows applications for DB2 UDB
(Jeremy McGee) In this two-part series, we show you how to use Borland Enterprise Core Objects (ECO) in Borland C#Builder Architect to build a powerful application for IBM DB2 Universal Database (UDB) that is powered by a UML model. This second article shows how ECO can quickly build complex user in
Benchmarking Performance of a Query – Part 1 Elapsed Time
(Gregory A. Larsen) How many times have you had more than one way to do something and wanted to determine which method was faster and/or which one used more resources? I am going to guess that most developers have run across this dilemma more than once. So how do you decide with method is faster–or
Meet the Experts: Connie Nelin on DB2 Application Development
Connie Nelin is a Distinguished Engineer in the IBM Database Advanced Technology area. She has worked for IBM since 1987 with a focus on database application development support and tooling. Connie currently has overall responsibility for application development tooling strategy, architecture and de
Oracle Backup and Recovery Essentials
Oracle database backup and recovery is an inherently challenging process that becomes more difficult as databases grow in size and as increasing demands on database availability limit the time available to perform backups. Many organizations use custom-made scripts and manual backup methods to prote
Can an Apache XMLBeans Help Speed Java Devs on XML?
(Vance McCarthy) BEA wants to jump-start the Java community’s work on supporting XML standards and dev tools. Concerned that today’s Java efforts are moving too slowly, BEA has handed over its internally developed XMLBeans technologies to the Apache Software Foundation (ASF). “XML support is an
Enhanced Security Tool Posted to Microsoft.com
(Scott Bekker) Microsoft posted a minor update this week of its free Microsoft Baseline Security Analyzer (MBSA) for download from its Web site. MBSA 1.2 is the first new version in about a year of the tool for locally or remotely identifying common security misconfigurations and scanning for mi
Using Oracle PL/SQL
PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other.