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

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.