Field/Column Names

[John Hall <jhall@xxxxxxxxxxx>]

Rob Berendt wrote:
> 
> John,
> How will converting to 6 character IBM RPG II field names make converting 
>from an Oracle database where the field names are larger any easier?  Don't 
>you have to then change every field that exceeds 6 characters into 6 
>characters or less? :-(


That was my point - if you use the least common denominator on all
databases (6 char fields, no special char, etc) then everything will
work.  I didn't say I would do it that way !!  TOO UGLY !!

On new projects we generally stick to 10 char or less for column names. 
It causes less headaches down the road or when trying to add files to
older programs.  I have seen databases on both extremes.

TheCommencmentDateOfContractField 
or
CD

Neither one is very useful. 



John L. Hall
Home Sales Company.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---