Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Queries against a DB2 linked server return a fixed quantity of bytes??

    Thanks Steve!

    Luckily, I found the answer:

    Open the ODBC entry, go to "Performance" -> "Advanced" -> and uncheck "Use blocking with a fetch of 1 row"

    Regards,

    Alejandro

  • RE: Delete to AS400 linked Server restricted by size

    One question:

    were you able to execture SELECTs that return more than those 66k?

    Cause I just posted a question that looks a lot like yours, only for SELECTs. Here is what...

  • RE: Linking a DB2 AS400 server

    Where can I get that one? I searched google for "Client Express Toolkit" and got noting...

    And finally, do you have any idea of how I can install the "Client Access...

  • RE: Linking a DB2 AS400 server

    Never mind!! Got it!! I just had to repeat the server's name as Database (without domain qualification). Something like:

    SELECT DISTINCT name  FROM [SRV1.mydomain.com].[SRV1].[LIBTEST].[SOMETABLE]

    Thanks a lot for your help!!! 

  • RE: Linking a DB2 AS400 server

    Ok, I read that syntax somewhere. The problem is that I don't know what to use as <DatabaseName> . I mean, when I enter...

  • RE: Linking a DB2 AS400 server

    YOU-ARE-THE-MAN!!!

    I have really been around with this... thanks a lot!!!

    Just a brief follow up:

    Can you tell me how to write the sql? (server,...

Viewing 6 posts - 1 through 6 (of 6 total)