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?
NOTICE: 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.
This topic has been locked.
1 reply Latest Post - 2010-09-28T13:12:12Z by DGawron
Pinned topic Database qualifier in SQL builder
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-09-28T13:12:12Z at 2010-09-28T13:12:12Z by DGawron
DGawron 10000054HC251 PostsACCEPTED ANSWER
Re: Database qualifier in SQL builder2010-09-28T13:12:12Z in response to deepak_csc_indiaSQL 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.