Getting Data from an AS400 member table (1 Viewer)

Djblois

Registered User.
Local time
Today, 11:40
Joined
Jan 26, 2009
Messages
598
I am using many tables from our AS400 in my access database but now I need another table this is something called a member table.



Here is a link on how to work with member tables in SQL in general but I cannot figure out how to work with it in access because when I use the link table manager it gives me no choice to add the member:


https://dba.stackexchange.com/questions/150677/select-all-data-from-ibm-db2-member-table
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 11:40
Joined
Oct 29, 2018
Messages
21,454
Are you trying to connect to AS400 using an ODBC driver?
 

Djblois

Registered User.
Local time
Today, 11:40
Joined
Jan 26, 2009
Messages
598
Not simply connect to AS400, as I figured that out a while ago. I am already connected with numerous tables. This is a specific type of table called a member table which is why I gave the only link I can find on it.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:40
Joined
Oct 29, 2018
Messages
21,454
Not simply connect to AS400, as I figured that out a while ago. I am already connected with numerous tables. This is a specific type of table called a member table which is why I gave the only link I can find on it.
Sorry I wasn't helpful. I guess you might need an IBM person to help you with this. Unfortunately, I only know SQL. Good luck!
 

Users who are viewing this thread

Top Bottom