IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2010-09-28T13:12:12Z by DGawron
1 Post

Pinned topic Database qualifier in SQL builder

‏2010-07-21T12:57:40Z |
We are using sql call builder in which queries dont use namespace. backend is DB2.

on application server, we had configure "currentSchema". but it seem queires in sql call builde still uses user id as databse qualifier.

I want queirs in sql builder to use currentSchema property set on application server.

Can someone suggeest how to proceed on it?
Updated on 2010-09-28T13:12:12Z at 2010-09-28T13:12:12Z by DGawron
  • DGawron
    251 Posts

    Re: Database qualifier in SQL builder

    ‏2010-09-28T13:12:12Z  in response to deepak_csc_india
    SQL Call doesn't set the CURRENT SCHEMA for a connection; it should be using whatever is set as the prevailing CURRENT SCHEMA for the connection it gets from the pool. Make sure the connection pool for the datasource is setting CURRENT SCHEMA when connections are first created. It is possible that something may be changing the CURRENT SCHEMA setting after connection are created, but it's not SQL Call; that builder only executes the SQL you provide in the Statement input.