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






Thanks for responses I will check this later. I got my files over for now. The problem was I have to refresh the Crystal Reports and my file will show. HOwever, it has to be under the letter "E". I want to find out why this is.

________________________________
From: "midrange-l-request@xxxxxxxxxxxx" <midrange-l-request@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Monday, June 10, 2013 9:05 AM
Subject: MIDRANGE-L Digest, Vol 12, Issue 1252


Send MIDRANGE-L mailing list submissions to
    midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
    midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
    midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

  1. Re: Not all AS/400 files are shown as tables (CRPence)
  2. Re: Not all AS/400 files are shown as tables (Glenn Gundermann)
  3. Re: Not all AS/400 files are shown as tables (rob@xxxxxxxxx)
  4. Re: list of open descriptors (Mike Krebs)
  5. LTO4 storage (rob@xxxxxxxxx)
  6. Re: LTO4 storage (rob@xxxxxxxxx)
  7. RE: LTO4 storage (Gary Thompson)


----------------------------------------------------------------------

message: 1
date: Sun, 09 Jun 2013 12:47:36 -0700
from: CRPence <CRPbottle@xxxxxxxxx>
subject: Re: Not all AS/400 files are shown as tables

On 08 Jun 2013 19:52, Crystal Reports wrote:
I am looking in the Crystal Reports Database setup. There you can see
some libraries with tables and views. I recently created a quick work
file that I want to use in Crystal Reports. But it doesn't show up in
the list. Also created a view off it and this too does not show.
Library is correct.

Work file was created via old Query 400. Is there any process needed
so that the file will show up as a table for crystal?

  Does whatever was established for the "Database setup" effect both
selection and ordering for which the new ad-hoc file and the SQL VIEW
should be included [i.e. not filtered-out] and should be presented
conspicuously in a predictable location relative to other entries in the
list [i.e. collated]?

  If not, then make modifications to ensure both concerns are resolved,
with regard to how the list of views+tables is generated and presented.

  If so, then verify the non-TABLE physical file and the SQL VIEW are
both visible in the TABLES catalog VIEW in both QSYS2 and SYSIBM.  If
TABLES does not exist, then defer to SYSTABLES.  If the files are not
found in a query of those catalog VIEWs, then likely the SQLTables() API
request that Crystal Reports presumably uses would also exclude them,
and is indicative of an apparent problem; e.g. the files may not even be
tracked in the underlying physical data, or they the rows that represent
those files are being excluded for some reason.  Or if the files appear
in one catalog VIEW but not the other, then ensure that the
authorization Id used for the Crystal Reports connection has authority
to both of the *FILE objects.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.