I hope you don’t mind another question about the “old” stuff. How do I program for the Dup key in a data entry subfile?

–David

This is a good technique to know, David, and it’s not hard to do.

Let’s start with a simple subfile of 10 records per page. There are three input fields: a date; a customer number; and an amount. Here’s the DDS:

A                                      DSPSIZ(24 80 *DS3)
A                                      INDARA
A          R SFL                       SFL
A            SDATE          6S 0I  8  6DUP(31)
A            SCUST          8A  I  8 16DUP(32)
A            SAMOUNT        7Y 3I  8 30DUP(33)
A          R CTL                       SFLCTL(SFL)
A                                      SFLSIZ(12)

UDTs or User-Defined Types (also known as distinct types) allow SQL developers to implement their own data types. For example, if a database contains many tables that each have one or more columns representing a general ledger account number defined as VARCHAR(30), a suitable UDT can be defined as follows:

Create Type My_Schema/GL_ACCOUNT_NUMBER As VarChar(30) CCSID 37
With Comparisons

In DB2 for i, implementing UDTs is currently limited to deriving a new data type from an existing DB2 built-in data type. This tip will briefly explore UDTs, how they can be used in modern databases, potential pitfalls, and how UDTs

One of the companies I work with performed its first live Capacity BackUp (CBU) switch test last month, where they switched over and used their CBU system as their live production system for several days. In the next few issues, I’ll use their experience in prepping for a live switch as a possible guide for others trying to ensure that their CBU can substitute for a live system.

CBU 101: Understanding the CBU

A CBU is an i, System i, or iSeries machine that is an exact duplicate of a live production system. CBUs generally contain the same amount of