× 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.


  1.  Home
  2. MIDRANGE-L
  3. October 2010

Re: SQL database object names longer than 10 characters and mixedcase?


< DB2/400 stores the long names somewhere; I don't know where and I don't
need to know >

They are in QSYS/QADBXREF...

;-)

- sjl



Dan wrote:
I use long names religiously.
create table rjsflow.somelongname ... ;
select * from rjsflow.somelongname;
Notice I also use SQL naming convention. Just as religiously.

I can do this on a 5250 from STRSQL or more often from OpsNav or java
JDBC.
DB2/400 stores the long names somewhere;
I don't know where and I don't need to know.
DB2/400 will make up a short name (or I can use he LABEL statement)
for the name it puts on the file in the library.
For most of the stuff I do, I don't ever use the short name.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.