AS400 ODBC Connection

[Guest]

It's been a while since I've posted here. I need to create an odbc connection
to an AS400 library that uses members. The system hierarchy is: Library >
Table > Member. I tried Library.Table.member, but I get an error. Does anyone
know the correct syntax to write the connection string?

Thanks for the help
Rosco

 

[Rick Brandt]

It's been a while since I've posted here. I need to create an odbc
connection to an AS400 library that uses members. The system
hierarchy is: Library > Table > Member. I tried Library.Table.member,
but I get an error. Does anyone know the correct syntax to write the
connection string?

Thanks for the help
Rosco

AFAIK you can only access the first member via ODBC. On the AS400 you can
create logical files that point at the other members and then use ODBC to
link to those Logical Files instead.

If you can find the guy that set up a multi-member table slap him silly.
Even IBM has discouraged this for years.

 

[Guest]

AFAIK you can only access the first member via ODBC. On the AS400 you can
create logical files that point at the other members and then use ODBC to
link to those Logical Files instead.

If you can find the guy that set up a multi-member table slap him silly.
Even IBM has discouraged this for years.
I'll show her your post.

Thanks Rick. In the 5 years I've been working here, this is the first time
I've come accross this.
I'll have her export to a flat logical table.