AS400 ODBC Connection

R

Rosco

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
 
R

Rick Brandt

Rosco said:
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
Click to expand...

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.
 
R

Rosco

Rick Brandt said:
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.
Click to expand...
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.
 
Top