Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

AS400 ODBC Connection

Discussion in 'Information Technology' started by Rosco, Oct 27, 2005.

  1. Rosco

    Rosco
    Expand Collapse
    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
     
  2. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Rosco wrote:
    > 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.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     
  3. Rosco

    Rosco
    Expand Collapse
    Guest

    "Rick Brandt" wrote:

    > Rosco wrote:
    > > 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.
    >

    I'll show her your post.
    > --
    > I don't check the Email account attached
    > to this message. Send instead to...
    > RBrandt at Hunter dot com
    >

    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.
     

Share This Page