0 Replies Latest reply: Apr 2, 2015 9:37 AM by Marcel LHOMME RSS

    Connector Iseries OLEDB JOBD *USRLIBL

      Hi every one.

       

      I have a question about connection of my project with a DB2 Database.

       

      Currently, I successfuly connect my database with my project, but I wouldn't like define the library of my datatable in my query for the extraction.

       

      For exemple:

      At the place of : Select * FROM LIB.PUPGA

      I would like to use: SELECT * FROM PUPGA

       

      To obtain this result, I would like retrieve the list of libraries from a user by his ID (JOBD). But I don't know where I need do put parameter "*USRLIBL" in my OLEDB Connection.

       

      Does anyone have the answer to my question?

       

      Thank you in advance

       

      Regards

       

      Marcel