From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, February 29, 2008 11:57 AM
To: Midrange Systems Technical Discussion
Subject: Re: DDS modernization - use of REFFLD
Here's the rub. Many people still name their fields based on the file
they are in. For example, if I have a field called ITEMNUM in FILEA
and FILEB they will call it AITEMNUM in one and BITEMNUM in the other.
Rather silly. Especially with prefix, or qualified, now if you are
concerned about field name collisions. Even prior to prefix I've seen
system i vendors who named the field the same. Naming it the same
would allow you
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
I suppose you could alter this to
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA FROM
syscolumns WHERE SYSTEM_COLUMN_NAME like('%ITEMNUM')
You still can do the DSPFFD on printer and display files. There's
currently no plans to convert that to DDL that I am aware of.
Group Dekko Services, LLC
Kendallville, IN 46755
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/29/2008 12:43 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject DDS modernization - use of REFFLD
Yesterday I received a change request that requires an existing PF
field to be increased in size. The actual program changes are trivial
- the main effort will be to identify which display files and printer
files use that field and verify that no other information will be
overlaid by the new, longer field.
Even if we didn't have a cross-reference utility, in our DDS-defined
system this would be fairly simple - dump the DSPFFD to an outfile and
query for the appropriate REFFLD.
Without a utility, I'm not sure how you'd do the equivalent task in a
DDL-defined system. Query the column-label or column-text and hope
that the designer specified everything consistently?
This is not intended as a criticism of DDL, I'm only trying to
understand how you DDL-guys tackle situations like this. If we end up
redefining everything in DDL, what other things should we watch out
Many thanks, JK