Library Lists in DB2 Adapter RRS feed

  • Question

  • Hello,

    Is it possible to define a library list in the AS400 (many libraries, separated by commas or semi-colons) in the DB2 adapter connection string? As far as I can see the default library setting allows only one library, 10-character long.

    Thanks in advance,


    Wednesday, October 27, 2010 10:11 AM


  • No you can not do this. It has been suggested in the past. You can leave out the default schema name, and that is one 'workaround', but you could have some issues with some queries, such as where there could be the same tablename in multiple schema's.

    Charles Ezzell - MSFT
    Thursday, November 4, 2010 9:42 AM