Re: should QSYS2 be in system portion of Library list?

I will grant you that there is quite a difference between 'system name'
and 'SQL name'. When it comes to SQL name, IBM tries to follow the norm.
If you've ever seen SQL Server or any number of other SQL packages you
will see a similar "system catalog" with things in there like SYSCOLUMNS
and SYSTABLES. Are you suggesting that all future catalog additions have
obfuscated system object names that begin with Q? While their 'SQL name'
be meaningful? I suppose you could suggest that with a 'Request for
Design Change' or a COMMON Requirement.

What is really a hoot is when they create SQL built in functions that
match existing column names. For example, when they created RID for row
id. Which happened to be the name of an existing column in Infor's FRT
table (record id, think old active record code). This didn't cause any
existing embedded SQL to collapse but if you went to recompile that
program you had to start enclosing the column name with double quotes
("RID") if you wanted the active record code versus the reserved word, row
id. I'm willing to bet there's no way IBM would obfuscate the BIF, (nor
would I want them to).


Rob Berendt