Accessing Multiple AS400 File Members using Crystal Reports

Posted on 2004-10-26
Last Modified: 2008-03-10
Currently i am trying to write a report which will access an AS400 database file, this file will have many file member and i am having trouble determine how i can access specific file member when retrieiving the data from the file, currently it is just using the first file member on the as400 file.
Question by:jdwan
    LVL 100

    Expert Comment

    I am not familiar with AS400 databases.  What is a file member?

    LVL 100

    Accepted Solution


    Author Comment

    Basically when you create a file on the as400 the system normally creates a file member with the same name as the file, which stores all the records (data) , this is generally how files on the as400 are created, however it is also possible to have a file which will actually have multiple file members, which means each file member will have a different set of data.

    Example: The following is from the file (called FIN890W1) this file has the members FIN890W1, GRDC71021, GRDC710437, and GRDC710440 as you can see by the records column the FIN890W1 member is empty, what i want to be able to do is report on the other file members.

    Member List                                                                          
                                                   Creation    Last      Change                      Deleted
    Member                    Size          Date         Date     Time          Records    Records
    FIN890W1                32768        27/10/04 27/10/04 12:38:18             0          0    
    GRDC710121           229376        27/10/04 27/10/04 13:07:20       1844          0    
    GRDC710437           229376        27/10/04 27/10/04 12:45:51       1788          0    
    GRDC710440           147456        27/10/04 27/10/04 12:46:32         922          0    
    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 ( But the ability to create custom scanning profiles al…
    In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…

    933 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now