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



  You would need to do a DSPJRN to an outfile.  You
can specify which journal entry types you want (there
are, of course, numerous selection criteria).  DSPJRN
will dump all of the entries into the "generic-format"
of QADSPJRN/QADSPJR4.  This is "generic" in the sense
that the entry-specific data is lumped into one big
herking field, unlike the entry-specific QASYxxJ4
files that list these in separate columns.  Hence my
suggestion to then use the QASYxxJ4 files as
externally described DS's.
  There are a couple of API's you can use to retrieve
the journal entries if you would rather do it that
way.
  Maybe this would work for you.
Don Whittaker

--- "Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx> wrote:

> Don, Thanks for the reply.  As I read your reply I
> started thinking
> about what I was doing.  I took off qualifying
> (qtemp) on my Select
> statements and that resolved my initial compile
> issue.  
> I'm definitely trying to avoid the 'ugly' so your
> point about using
> QSYS/QADSPJRN or QSYS/QADSPJR4) is definitely worth
> looking at.  Yours
> was a very timely response-btw.  
> However, I'm not sure I know how to use these files.
>  I know when I do a
> DSPAUDJRNE I get a bunch of QASYxxJ4 files
> populated, but what is going
> to populate the files (QADSPJRN,QADSPJR4)???
> 
> Michael Smith
> iSeries.mySeries.
> 



                
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.