Topic
  • 6 replies
  • Latest Post - ‏2013-06-27T19:45:35Z by GeorgeKY
GeorgeKY
GeorgeKY
4 Posts

Pinned topic data studio 3.2 and iseries library list

‏2013-04-26T18:29:02Z |

hi,

I just installed 3.2 today and am trying to set my library list. I cannot figure out how to do so. It seems to default to my *curlib not mater what schema I set up. Can anyone point me in the right direction?

thanks in advance....

  • David.Zhu
    David.Zhu
    67 Posts

    Re: data studio 3.2 and iseries library list

    ‏2013-04-27T04:01:12Z  

    Hi,George,

    Could you describe what's the steps you do then met this problem and what's the behavior you expected?

    Currently, I can't understand you problem well.

    Thanks.

  • GeorgeKY
    GeorgeKY
    4 Posts

    Re: data studio 3.2 and iseries library list

    ‏2013-04-29T13:25:31Z  
    • David.Zhu
    • ‏2013-04-27T04:01:12Z

    Hi,George,

    Could you describe what's the steps you do then met this problem and what's the behavior you expected?

    Currently, I can't understand you problem well.

    Thanks.

    i am using data studion 3.2. I am setting up a connection to my iseries (ibm i, as400, etc..)  using DB2 for i, JDBC driver of AS/400 Toolbox for Java Default, and default schema of MyDataLibrary.

    In database development, I create a script using this connection. Unless I fully qualify the tables name, SQl tells me it cannot find my talbe in GeorgeLib, my current default library.

    It seems I cannot set any other libraries to search.

    I am also using RDP 8.0.3.

    does this help?

    thanks

    george

     

  • David.Zhu
    David.Zhu
    67 Posts

    Re: data studio 3.2 and iseries library list

    ‏2013-04-30T14:26:10Z  
    • GeorgeKY
    • ‏2013-04-29T13:25:31Z

    i am using data studion 3.2. I am setting up a connection to my iseries (ibm i, as400, etc..)  using DB2 for i, JDBC driver of AS/400 Toolbox for Java Default, and default schema of MyDataLibrary.

    In database development, I create a script using this connection. Unless I fully qualify the tables name, SQl tells me it cannot find my talbe in GeorgeLib, my current default library.

    It seems I cannot set any other libraries to search.

    I am also using RDP 8.0.3.

    does this help?

    thanks

    george

     

    Hi,George,

    Here the default library, do you mean the default schema?

    If yes, there are two way to change the default schema and then you don't need use the full qualify name.

    1. add the following line at the first line of you script.

    set current schema <schema Name>

    2.In the SQL editor, there is a tab "Special Register", in the tab, there is field "Current Schema".  change the values of to you preferred value. Then when access the objects in this schema, you don't need the full qualify name.

    Thanks.

  • GeorgeKY
    GeorgeKY
    4 Posts

    Re: data studio 3.2 and iseries library list

    ‏2013-05-10T21:02:09Z  
    • David.Zhu
    • ‏2013-04-30T14:26:10Z

    Hi,George,

    Here the default library, do you mean the default schema?

    If yes, there are two way to change the default schema and then you don't need use the full qualify name.

    1. add the following line at the first line of you script.

    set current schema <schema Name>

    2.In the SQL editor, there is a tab "Special Register", in the tab, there is field "Current Schema".  change the values of to you preferred value. Then when access the objects in this schema, you don't need the full qualify name.

    Thanks.

    David,

    The special register tab is grayed out, i cannot put an entry in there.

    I did try using the set current schema command - while the sql statement would run, it would not return any values. Once I removed it, and fully qualified the table name, i got results.

    so I am still kind of stuck here.

    thanks

  • artblose
    artblose
    2 Posts

    Re: data studio 3.2 and iseries library list

    ‏2013-06-22T19:57:46Z  

    Just installed this, and had the same issue. go to the driver properties on your connection, and click on "optional". Then, you can enter a library list in the following format:

     

    libraries=LIBRARY1 LIBRARY2 LIBRARY3

     

    If you have an iAsp, you need to enter the 

    databasename="isap name"

     

    to point to the proper iAsp. 

    I haven't tried others, but you can probably use any of the java toolkit keywords with this interface. A list can be found at

     

    http://pic.dhe.ibm.com/infocenter/iadthelp/v8r0/index.jsp?topic=%2Fcom.ibm.etools.iseries.toolbox.doc%2Fjdbcproperties.htm

     

    A screen shot of what I did is below (if it is allowed on this forum).

     

    Art

     

     

    Attachments

  • GeorgeKY
    GeorgeKY
    4 Posts

    Re: data studio 3.2 and iseries library list

    ‏2013-06-27T19:45:35Z  
    • artblose
    • ‏2013-06-22T19:57:46Z

    Just installed this, and had the same issue. go to the driver properties on your connection, and click on "optional". Then, you can enter a library list in the following format:

     

    libraries=LIBRARY1 LIBRARY2 LIBRARY3

     

    If you have an iAsp, you need to enter the 

    databasename="isap name"

     

    to point to the proper iAsp. 

    I haven't tried others, but you can probably use any of the java toolkit keywords with this interface. A list can be found at

     

    http://pic.dhe.ibm.com/infocenter/iadthelp/v8r0/index.jsp?topic=%2Fcom.ibm.etools.iseries.toolbox.doc%2Fjdbcproperties.htm

     

    A screen shot of what I did is below (if it is allowed on this forum).

     

    Art

     

     

    that worked!  Thanks