Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    3

    Question Unanswered: I have linked an as400 database to Sql 7.0, now how do I select data from it?

    I am trying to get data from an AS400 database (JD Edwards). I have created the linked server, and can see all the tables, but how do I reference them in a sql statement?

    Thank You

  2. #2
    Join Date
    Dec 2001
    Posts
    1
    Select * from [LinkedServerName.DatabaseName.OwnerName.TableName]
    Jaganmohan Rao

  3. #3
    Join Date
    Jan 2002
    Posts
    3
    How do I find the database name and owner name of the JD Edwards Database on the AS400?

    Thank You

  4. #4
    Join Date
    Jan 2002
    Posts
    3

    Thumbs up Figured it out - Thanks

    On the AS/400, I had to go to WRKRDBDIRE (Work with Relational Database Directory Entries).

    If an RDB Directory Entry doesn't exist for '*Local' on the AS400, one must be added. I created one named TEST for the local server.

    So, the final syntax is is like this:

    [Linked Server Name].[RDB Entry Name].[Library].[File]

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •