(Robert Catterall) Even if you have a team of very talented application programmers, they can still be doing the wrong kind of work and reducing the value that they deliver to the organization. One glaring example that I often see: using application code to do things that DB2 can do more effectively
Other News
Why is SQL Server Configuration Manager Missing Services
(Shawn Melton) When I open SQL Server Configuration Manager (SSCM) I see no services displayed (or just Integration Services). How can I resolve this quickly? Check out this tip for the solution.
War Story Rewind
2012 Topics Survey Here is your opportunity to help determine SSWUG courses for 2012. Click Here to take an online survey. It’s quick, easy, and you will be eligible for some pretty cool free stuff. War Story Our War Story newsletter didn’t distribute well yesterday. If this is a duplicate for some of you, my apologies. I’m not sure how […]
War Story
War Story I’m not sure how universal the term “War Story” may be, but this term is used to describe a painful event experienced in the life of an IT professional. It may be related to infrastructure, processes, software development, product management, software development lifecycles, etc. The value of a "war story" is that it provides real life experiences substantiating […]
Simple Outline XML and Slim
(Ben Atkin) There’s nothing new about expressing XML in a significant-indentation format. Here’s Slim next to one from 2001.
How To Leverage Structured Markup To Create E-Commerce Web Portals
(Barbara Starr) I’m sure most of you are familiar with the definition of a Web portal. Wikipedia defines it as a point of access to the Web with information from diverse sources represented in a unified way.
DB2 10 and DB2 9 Product Documentation has been refreshed (October 2011)
(Willie Favero) It’s was that time again, but I missed it. When the new month of October came in, somehow I managed to miss the October updates that came out. I must be slipping in my old age, or maybe there was just too much going on in October to notice that quite a few of product manuals had b
CTAS in a NOARCHIVELOG database is a NOLOGGING operation
(Hemant K Chitale) Normally, a CTAS (CREATE TABLE … AS SELECT ….) operation generates redo and logging. However, if the database is in NOARCHIVELOG mode, Oracle silently converts it to a NOLOGGING operation.
Transact-SQL: Limiting Results
(Buck Woody) In a previous article, I explained one of the most powerful constructs in the Transact-SQL (T-SQL) language — the SELECT statement. This most basic of statements is used to retrieve data from tables or views.
Practical SQL: UDFs and Service Programs, Part I
(Joe Pluta) We continue to provide you with examples of integrating SQL with traditional RPG. In this article, we’re going to focus on how we can use a service program to extend SQL and provide an essential feature that SQL is sorely lacking: converting binary data in a character field to numeric va