RE: SQL database object names longer than 10 characters and mixed case?

Pretty much correct except for the mixed-case part. (SQL will roll up the
name to upper case before matching the name.

An example view name might be CUSTOMERS_PAST_DUE. The system will create a
library object of type *FILE whose name is CUSTOMnnnn for this view, where
nnnn is a sequential number. In SQL, you may refer to the object with
either name.

Select distinct CustomerNumber from customers_past_due ;

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Everything is funny as long as it is happening to somebody else."
-- Will Rogers

I gather that is is possible to have SQL database object names on the
System i that are longer than 10 characters and mixed case. This could
be SQL tables, views, triggers, etc. I just can't see where they would
be used or stored. Perhaps in the IFS?

Has anyone actually used these long names, and if so, could you give me
an example? (Not the actual SQL code, but just a sample name, where
you
would store in on the system, and what type of application would use
it.)

Thanks.

--
Dave Murvin

www.drmetools.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.