Re: DDL Files - Tables and keys

[Doug Palme <DPalme@xxxxxxxxxxx>]

   Glad to know that my dumb questions helped us all so much :)

   From:     rob@xxxxxxxxx                                                    
   To:       Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>  
   Date:     08/19/2008 08:07 AM                                              
   Subject:  Re: DDL Files - Tables and keys                                  

     ----------------------------------------------------------------------

   Actually I did hear the giggles.
   If you have to modify a S/36 program at all to support members then it
   shouldn't be that hard to add a batch column in the table.

   Actually I find:
   Select batch distinct from InvoiceFile order by batch
   much easier to program than a call to the api QUSLMBR.
   to retrieve all the members.

   Rob Berendt
   --
   Group Dekko Services, LLC
   Dept 01.073
   Dock 108
   6928N 400E
   Kendallville, IN 46755
   http://www.dekko.com

   Terrence Enger <tenger@xxxxxxxxxxxxxxxx>
   Sent by: midrange-l-bounces@xxxxxxxxxxxx
   08/18/2008 05:18 PM
   Please respond to
   Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

   To
   Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
   cc

   Subject
   Re: DDL Files - Tables and keys

   On Mon, 2008-08-18 at 09:13 -0400, rob@xxxxxxxxx wrote:
   [snip]
   > What is so darned good about multi members that can't be solved by
   simply
   > adding another column that is indicative of what you used the member
   name
   > for?

   Hmm.  I shall try really hard not to be sarcastic.  We'll see
   whether I succeed.  Here goes.

   (*) Multi-member files work reasonably well on the AS/400 while
      not disturbing too much those S/36 programs and programmers
      which create files (e.g., per batch, or something) on the
      fly.

   (*) Batch identifiers within the record encourage scope-creep.
      It becomes really easy, using regular application programming
      techniques, to give a supervisor really advanced functions
      like a list of all open batches, for example.

   Okay, you didn't hear any giggles, did you?

   Cheers,
   Terry.

   --
   This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
   list
   To post a message email: MIDRANGE-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/midrange-l
   or email: MIDRANGE-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/midrange-l.

   --
   This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
   list
   To post a message email: MIDRANGE-L@xxxxxxxxxxxx
   To subscribe, unsubscribe, or change list options,
   visit: http://lists.midrange.com/mailman/listinfo/midrange-l
   or email: MIDRANGE-L-request@xxxxxxxxxxxx
   Before posting, please take a moment to review the archives
   at http://archive.midrange.com/midrange-l.

   This transmission may contain information that is privileged, confidential
   and/or exempt from disclosure under applicable law. If you are not the
   intended recipient, you are hereby notified that any disclosure, copying,
   distribution, or use of the information contained herein (including any
   reliance thereon) is STRICTLY PROHIBITED. If you received this
   transmission in error, please immediately contact the sender and destroy
   the material in its entirety, whether in electronic or hard copy format.
   Thank you.