Hi,
I was wondering just where a column names get the abreviated form they have in .sql files. How does Patriarch(Name) become Ptrrch_nm? Looking at the OIAL file, I saw that that it's still "Patriarch," but in the DCIL file it's now "Ptrrch." What causes the abreviation?
Traditionally, DB coulmn names are kept short. I'll agree there may be some good reasons for this in some types of production DBs. Still, I think fully expressive column names are preferable in prototype DBs, where they make it easier to see if things are as they should be.
RDBMSes do have limits on column length, but these are pretty generous in modern systems. I'd prefer that NORMA only abreviate column names when required to do so by the limits of a given RDBMS - if that's where it's being mapped. Would this be too hard to implement? Does it need to be done so early in the mapping process that the names have to fit the limits for the lowest common denominator amung possible mapping targets?
To me, clarity should come first, as there are ways to add effeciency later. I'd rather see "City_Tour_Date" than "Ct_Tr_Dt" anytime. If it helps to rename that to, or display as "Date" in the production DB table or form, that's easy enough to do. BRN..