Link file member in MS Access?

[mapperkids]

Hi,

I know how to create a linked table in MS Access to point to the file in AS400, but if the file contains different file members, how can I create a link table for that specific member? I don't see anywhere in ACCESS to let me pick the file member other than the fields.

Thanks!

[DeadManWalks]

Re: Link file member in MS Access?

That is because you can not. The *First member is always used. You will have to use some other method, ie copy the member to a new file.

[arrow483]

Re: Link file member in MS Access?

Try creating an alias

CREATE ALIAS library/aliasname 
	FOR library/filename(membername) ;

Then query the aliasname.

[DeadManWalks]

Re: Link file member in MS Access?

Thanks, that is a nice way to do it.

[mapperkids]

Re: Link file member in MS Access?

Try creating an alias

CREATE ALIAS library/aliasname 
	FOR library/filename(membername) ;

Then query the aliasname.

Thanks, where to create the ALIAS? access or AS400? the command seems not working on AS400, or should be CRT ALIAS?

[FaStOnE]

Re: Link file member in MS Access?

Create the Alias in QGPL or any other library that the MS Access has permissions to get to.

Then, instead of calling the original FILENAME (that has multiple members) call the Alias (which references the specific member)

-Rick

[DeadManWalks]

Re: Link file member in MS Access?

Hi, the CREATE ALIAS command is an sql command. So you with have to either use STRSL from a command line, STRQM or use Ops Nav.

[arrow483]

Re: Link file member in MS Access?

Easiest way, IMHO.
Open iSeris Navigator / Databases / Schemas / your-library / Aliases
Right click, select New / Alias and fill in the blanks.

[mapperkids]

Re: Link file member in MS Access?

Easiest way, IMHO.
Open iSeris Navigator / Databases / Schemas / your-library / Aliases
Right click, select New / Alias and fill in the blanks.

I got it and thanks a lot for all replied to my post