Creating an Alias for an AS400 file member

Posted on 2004-10-26
Last Modified: 2010-08-05
I am currently trying to access multiple physical file members using crystal reports, i have since found out to do this i need to be able to create an alias for the file members that i want to access, i am not sure how i create an alias for the members, currently our as400 doesn't support SQL Development Kit as we don't have a license. I was able to create an alias for a file member using ops navigator but now i can't access it, any help would be appreciated.

Question by:jdwan
    LVL 14

    Accepted Solution

    Hi you can do it through Query management

    Create a source file and put in it

    Then create the query

    CRTQMQRY QMQRY(Lib/CRTALIAS) SRCFILE(lib/srcfile) SRCMBR(member)      

    then you can create it using

    STRQMQRY QMQRY(CRTALIAS) SETVAR((aliaslib 'library') (alias 'ALIASXXXX') (filelib 'mtLibrary') (file 'myFile') (MEMBER  'mymbr'))  

    LVL 32

    Expert Comment

    You will also have to edit the QM permissions to run CREATE ALIAS statements.

    I think that you can execute RUNSQLSTM even in lack of SQL development kit,
    which means that you can create a source member with the CREATE ALIAS command in it, and RUNSQLSTM it.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    php iseries 3 204
    Define binary variable in RPG free d specs 5 93
    AS400 Forms 9 91
    Access Pass Through Query rounding off ending zeros 9 71
    Create and license users in Office 365 in bulk based on a CSV file. A step-by-step guide with PowerShell script examples.
    Great sound, comfort and fit, excellent build quality, versatility, compatibility. These are just some of the many reasons for choosing a headset from Sennheiser.
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 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

    13 Experts available now in Live!

    Get 1:1 Help Now