Re: Unexpected SQLSTATE returned from embedded SQL

FYI and that of others

Things like these SQL services do not come "with" TR7, their release is timed with the TRs. IOW, installing a TR does not get you the new stuff like for database or RPG or whatever.

To find out what is released along with TRs, one can go to developerworks.ibm.com - http://www.ibm.com/developerworks/ibmi is a starting point - there's a link there now to technology updates - take that, then find the DB2 section link on the next page.

Regards
Vern

On 7/18/2015 10:02 AM, CRPence wrote:

On 17-Jul-2015 07:28 -0600, Gary Thompson wrote:

<<SNIP>> a re-run returns: SQL5016 "Qualified object name
DISPLAY_JOURNAL not valid." Which, to me, confirms no TR7 <<SNIP>>

FWiW: Not sure what came with TR7 [the UDTF named DISPLAY_JOURNAL in QSYS2 and\or the ability to use the period (.) character *SQL qualifier when using *SYS naming], but that message signifies only that the qualification [using period vs slash] is unsupported with NAMING(*SYS); i.e. that error does not indicate that the UDTF does not exist.