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?
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 Posts
Re: Database qualifier in SQL builder2010-09-28T13:12:12ZThis is the accepted answer. This is the accepted answer.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.