[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Creating an Alias for an AS400 file member

Posted on 2004-10-26
Medium Priority
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

daveslater earned 1500 total points
ID: 12419513
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 33

Expert Comment

ID: 12427213
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.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I came across an unsolved Outlook issue and here is my solution.
Tech giants such as Amazon and Google have sold Alexa and Echo to such an extent that they have become household names. And soon they are expected to be used by commoners in their homes, ordering takeout, picking out a song, answering trivia questio…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

872 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