RE: File field names

[Marco Facchinetti <facchinetti@xxxxxxxxx>]

Just consider this case: CUSTOMER the field name is talking
but if I use it in a billing program I will have a delivery
CUSTOMER, a billing CUSTOMER, ordering CUSTOMER...
If they are on the same record format I MUST rename them.

Having the same names across files will force you to rename
(almost) all the files and, using SQL (or relatives), to
fully reference the fileds (filename.fieldname).

Anyway I'm still don't know where I can find then
referenced field (beside DSPFFD > *OUTFILE).

--- rob@dekko.com wrote:
> 
> That's your problem, right there.  You're adding a prefix
> when you code a
> PF.  For example, if you called the item number ITEMNUM
> in both ITEMMAST
> and ORDDET then a simple query against the file
> QSYS/QADBIFLD would show
> you everywhere the field is used.  If you want to use the
> two files in the
> same program then you simply do a PREFIX on the F spec in
> RPGIV.  There are
> commercial canned software applications out there which
> do this.  They
> actually work and make sense.  People can adapt.
> 
> Adopting this technique makes referencing obsolete. 
> Except maybe in screen
> or printer files.
> 
> Rob Berendt


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---