×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
No IFS involved here. The SQL created tables get two names. A long SQL only name and a short 10 character name. Short name is usually auto generate but you can set it yourself. Auto generate would be something like PERSO00001 for a table name "Personal Master File" First 5 characters plus a 5 digit number auto incremented when there are duplicates. Fields (columns) are treated the same
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Murvin
Sent: Friday, October 29, 2010 12:27 PM
To: Midrange Systems Technical Discussion
Subject: SQL database object names longer than 10 characters and mixed case?
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.
midrange.com
