Re: Unexpected SQLSTATE returned from embedded SQL -- RPG400-L

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

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.

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.