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.

Granted that neither DSPJRN not the DISPLAY_JOURNAL service will parse the data - as for prompting, well, do you expect prompting for other SQL activities? At the level of IBM i commands? I know that I don't.

So one does need tools - the SQL service, I think, could be used very nicely to build such tools, and you have all the selectivity of SQL against the result set. It will give you the before and after images just as DSPJRN will, albeit in raw form, which you need to be made readable - as do we all, right?

Cheers
Vern

On 7/20/2015 11:31 AM, D*B wrote:

BTW Vern, renaming Oops Nerv to something else doesn’t add any value to the customers. Name me outdated, I’m needing tools and no toys! Regarding the UDTF to display Journal data, I’m not seeing any benefit compared to DSPJRN. DSPJRN is by far easier to use with all it’s prompting and what I’m missing is: I need the contents of the before and after images in a readable presentation and the ability to analize the images with SQL – and for this you have to develop your own tools (or some open source and freeware, as provided by some guys, including me).

D*B

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.