Re: Should short name always be equal to long name for object

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

The UDTF is implemented by service program QDBSSUDF2 QSYS QDBSSUDF2 DB TEAM SYSTEM SUPPLIED UDFS, procedure QSQOBSTAT.

On 2/17/2015 2:15 PM, CRPence wrote:

On 17-Feb-2015 13:35 -0600, rob@xxxxxxxxx wrote:

See subject, then run this query

SELECT OBJNAME, OBJTYPE, OBJATTRIBUTE, OBJLONGNAME
FROM table(qsys2.object_statistics('QSYS2', '*ALL')) X
ORDER BY OBJLONGNAME

<<SNIP>>

I just now posted a delayed response to Glenn having called-out something similar [but more open to interpretation than the above scenario]. <http://archive.midrange.com/midrange-l/201502/msg00470.html> As I alluded there, the logical conclusion is that the presentation of anything other than the intuitively correct value for the /SQL long name/ would seem to be a defect with the output of that system-supplied UDTF. No, there would seem to be no logical reason [other than a defect] that the /long name/ presented for ObjLongName would be anything other than the long name assigned by the SQL CREATE [or RENAME] statement.

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.

Re: Should short name always be equal to long name for object_statistics?