• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Use the Dup Key in Subfiles

    September 2, 2009 Hey, Ted

    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)
    
    …

    Read more
  • An Overview of User-Defined Types in DB2 for i

    September 2, 2009 Michael Sansoterra

    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

    …

    Read more
  • Admin Alert: The Road to Live CBU Fail Over, Part 1

    September 2, 2009 Joe Hertvik

    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

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle