Topic
  • 1 reply
  • Latest Post - ‏2013-06-26T23:49:46Z by JM3C_Tony_Leung
LenStockdale
LenStockdale
1 Post

Pinned topic SQL SYSTEM NAMING

‏2013-06-12T13:59:01Z |

Hello.

I am using Data Studio 3.1.1.0.  I am creating SQL Stored procedures for use with DB2 Web Query.  How do I compile/deploy a stored procedure to use System naming.

Basically I am trying to find a method whereby I do not have to hard code the library name in the SQL statement i.e. SELECT * FROM mylib.mytable. I would like to use SELECT * FROM *LIBL.mytable or SELECT * FROM mytable.

Thanks

Len

 

 

 

  • JM3C_Tony_Leung
    JM3C_Tony_Leung
    5 Posts

    Re: SQL SYSTEM NAMING

    ‏2013-06-26T23:49:46Z  

    Hi Len,

        System naming is only supported with the AS/400 Toolbox driver. If you define a connection profile with the "AS/400 Toolbox for Java Default driver" jdbc driver, under the "Optional" tab in the properties section you can add a property "naming" with the value "system". I have attached a png file named system_naming.png to show you the screenshot. Please let me know if this doesn't work for you.

    Thanks

    Tony

    Attachments