Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34

    Unhappy Unanswered: Querying AS400 using OPENQUERY

    Im currently trying to query an AS400 table which I know contains 18 rows. However when executing a query through Query Analyzer' using

    SELECT * FROM OPENQUERY(SERVER_NAME,'SELECT col1,col2,col3 FROM DS.TABLE')

    I'm only getting one row returned.

    Has anyone any experience of this kind of issue, and if so a resolution?

    Cheers

  2. #2
    Join Date
    Mar 2004
    Location
    West London
    Posts
    34

    Re: Querying AS400 using OPENQUERY

    Originally posted by SQLSurfer
    Im currently trying to query an AS400 table which I know contains 18 rows. However when executing a query through Query Analyzer' using

    SELECT * FROM OPENQUERY(SERVER_NAME,'SELECT col1,col2,col3 FROM DS.TABLE')

    I'm only getting one row returned.

    Has anyone any experience of this kind of issue, and if so a resolution?

    Cheers
    Now sorted

Posting Permissions

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