Note: The code accompanying this article is available for download here.

Way back in May 2009, I wrote about some of my experiences with Javascript. Well, time has moved on and I, hopefully, have become a more experienced Javascript programmer. Part of that experience has been in coming to grips with the many Javascript libraries and frameworks that are available for download.

When it comes to Javascript, here is what has been happening to me. I came across a requirement for a feature on a Web page (e.g., a calendar to allow the selection of dates), so I did

Is there a way using SQL to calculate the amount a numeric column changes from one row to the next?

–Ken

Yes. Here’s how it’s done.

First, you need a table to use for an example.

create table mydata
 ( Name char(8), Qty dec(3,0))

insert into mydata values
  ('Bob',   25),
  ('Bill',  85),
  ('Sue',   17),
  ('Bob',   28),
  ('Bob',   32),
  ('Bill', 105),
  ('Sue',   45)

To pull this off, the data must be stored in the order in which it is to be retrieved. If necessary, create a temporary table to hold the sorted data.

declare global temporary table SortedData as
  (select name, 

As we approach year end, I usually clear out my Admin Alert mailbox to see if there’s any good additional information about recent articles that I can pass along to you. Good thing, too, as some readers sent over workable ideas about getting into semi-restricted state and how to handle vendor profiles for auditors. Here’s what they said. I hope this information helps you.

On Semi-Restricted State TCP/IP, Suggestion #1

About my article on putting an IBM i system into semi-restricted state (where the system is down but TCP/IP is up), reader Richard Shearwood filled in some gaps about