Actually, I know which fields are from database files by their names.  So
far every application I've worked on, or written, for the AS/400 so far have
had naming schemes to distinguish field variables from program variables.
In one application the first 2 characters out of 6 stated what file it was
from.  In another program the last 2 characters stated what file it was
from.  In databases I've designed, I've used the first 2 chars.

True, CMZIPC may mean next to nothing, but it tells me that, first it's from
the Customer Master file and 2nd, it's a ZipCode.  Not to be confused with
VMZIPC which is the Vendor Master zip code.

ZIPC or ZIPCODE would be a program variable.

Regards,

Jim Langston

-----Original Message-----
From: Joe Pluta [mailto:joepluta@PlutaBrothers.com]

...I wonder how you get
that same information - for example, which fields are from database files.
Perhaps you intuit it from the source?  Now THAT would truly be an awesome
skill.

Joe


This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.