(Azim Fahmi) I need to create a 10 character alphanumeric sequence for a client. The sequence is to be static like this: a111a11a11a. If it’s a number, increment 1 until you reach 9, then move to the next column, if it’s a letter, increment 1 until z, then move to the next column. Can you suggest a
Author: SSWUG Research
Free upcoming one day DB2 seminar ‘Preparing and Optimizing for Today and the Future’
(Willie Favero) This is an announcement write-up taken directly from an IBM flyer. Attend one of our free technical education seminars to learn the value that DB2 for z/OS Version 8 can bring to your enterprise – and get a sneak peak of DB2 9 for z/OS. (R)
Error message when you install SQL Server 2005: ‘Beta components detected’
When you install Microsoft SQL Server 2005, you may receive the following error message: Beta components detected.
Extracting Data from a Flat File with SQL Server 2005 Integration Services
SQL Server Integration Services (formerly Data Transformation Services) provides a comprehensive solution for transferring and transforming data between diverse data sources. The architecture of SSIS has been redesigned to separate package-control flow from data flow. Two engines have been int
To SP or not to SP in SQL Server: an argument for stored procedures
(Adam Machanic) A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve the use of stored procedures. A popular article on the Simple-Talk Web site (To SP or Not to SP in SQL Server) discussed various pros and
Fetching Even and Odd Records in Oracle
(MS Sridhar) This tip will help you understand how to apply the mod function and use it to obtain even and odd records from columns in Oracle.
Oracle Takes Aim at SAP Customers
Oracle plans to set up a Solution Support Center for R/3 support providers to help them run the SAP applications on Oracle databases. The company says the support services Systime will offer could cost 55 percent less than SAP charges.
Develop configurable software applications with ease
(Obi Ezechukwu) The Obix Framework is an XML and Java configuration framework that provides developers with the ability to easily and quickly develop configurable software applications. This tutorial is a quick and short introduction to the framework, which demonstrates how to develop configurable J
The Ajax transport method
(Jack D. Herrington) Discover three Ajax data transport mechanisms (XMLHttp, script tags, and frames or iframes) and their relative strengths and weaknesses. This tutorial provides code for both the server side and the client side and explains it in detail to provide the techniques you need to put e
Automatically generate classes and enums from sql datatables
(stewartamackenzie) With many applications, the SQL database doesn’t only hold the business data. There is a good chance that the sys.messages table holds custom messages for the application and that another table may be used for application wide defaults. These repositories for messages, defa