Re: How Do I Change Schema

2009-09-01 Thread Hugh Ross
a 'SET CURRENT SCHEMA = XXX' > > http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.ref.doc/doc/r0005877.html > > Mario > > > -- > View this message in context: > http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p25025072.h

Re: How Do I Change Schema

2009-08-18 Thread pczurak
View this message in context: http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p25025072.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-java-unsubscr...@i

Re: How Do I Change Schema

2009-08-17 Thread Mario Ds Briggs
18/08/2009 11:17 cc Subject Please respond to Re: How Do I Change Schema

Re: How Do I Change Schema

2009-08-17 Thread pczurak
:58 cc > >Subject > Please respond to Re: How Do I Change Schema > user-j...@ibatis.

Re: How Do I Change Schema

2009-08-17 Thread Mario Ds Briggs
Subject Please respond to Re: How Do I Change Schema user-j...@ibatis. apache.org

Re: How Do I Change Schema

2009-08-17 Thread Clinton Begin
arameter is filled in. This gets >> called before the statement is prepared, so presuming that your >> parameterObject reports 'freddy' in response to >> parameterObject.getNamespace(), your statement would then be prep

Re: How Do I Change Schema

2009-08-17 Thread pczurak
> > SELECT name, title, id > FROM freddy.person > WHERE person_uid = '?' > > and then the parameterObject would be asked for the accession argument as > before. > > You should be aware though that this is a "danger

Re: How Do I Change Schema

2009-08-17 Thread Andy Law
. You should NEVER use $varName$ insertion without rigorously checking the value being inserted. Hope that helps. Later, Andy -- View this message in context: http://www.nabble.com/How-Do-I-Change-Schema-tp24948645p25008285.html Sent from the iBATIS - User - Java mailing list archive at Nabble.co

Re: How Do I Change Schema

2009-08-13 Thread pczurak
.html >>>> >> >>>> >> >>>> >> But it does not explain what file or where, so I though maybe >>>> someone >>>> in >>>> >> this forum would know. >>>> >> >>>> >

Re: How Do I Change Schema

2009-08-13 Thread Jeff Butler
org/msg09212.html >> >>> >> >> >>> >> http://www.mail-archive.com/user-java@ibatis.apache.org/msg09212.html >> >>> >> >> >>> >> >> >>> >> But it does not explain what file or where, so I though m

Re: How Do I Change Schema

2009-08-13 Thread Clinton Begin
; But it does not explain what file or where, so I though maybe > someone > >>> in > >>> >> this forum would know. > >>> >> > >>> >> > >>> >> > >>> >> Clinton Begin wrote: > >&g

Re: How Do I Change Schema

2009-08-13 Thread Jeff Butler
t; >> >>> >> >>> >> Clinton Begin wrote: >>> >> > >>> >> > I suggest you remove the specific schema and log in as the >>> appropriate >>> >> > user >>> >> > and use the appropriate schema.  This can be

Re: How Do I Change Schema

2009-08-13 Thread pczurak
;> >> > clinton >> >> > >> >> > On Wed, Aug 12, 2009 at 10:26 PM, pczurak wrote: >> >> > >> >> >> >> >> >> I am using iBATIS 2.1 >> >> >> >> >> >> My quest

Re: How Do I Change Schema

2009-08-13 Thread Clinton Begin
gt; >> URL. > >> > > >> > But if they're hard coded as you have below... then you're in for some > >> > Search and Replace. > >> > > >> > clinton > >> > > >> > On Wed, Aug 12, 2009 at 10:

Re: How Do I Change Schema

2009-08-12 Thread pczurak
use the appropriate schema. This can be specified in your JDBC >> URL. >> > >> > But if they're hard coded as you have below... then you're in for some >> > Search and Replace. >> > >> > clinton >> > >> > On Wed, Aug 1

Re: How Do I Change Schema

2009-08-12 Thread Clinton Begin
riate >> > user >> > and use the appropriate schema. This can be specified in your JDBC URL. >> > >> > But if they're hard coded as you have below... then you're in for some >> > Search and Replace. >> > >> > clinton >

Re: How Do I Change Schema

2009-08-12 Thread Clinton Begin
t; > and use the appropriate schema. This can be specified in your JDBC URL. > > > > But if they're hard coded as you have below... then you're in for some > > Search and Replace. > > > > clinton > > > > On Wed, Aug 12, 2009 at 10:26 PM,

Re: How Do I Change Schema

2009-08-12 Thread pczurak
nton > > On Wed, Aug 12, 2009 at 10:26 PM, pczurak wrote: > >> >> I am using iBATIS 2.1 >> >> My question is how do I change Schema name for DB2 database? >> >> Schema.tablename >> >> ex: Select * from TEST.Payroll Payroll where amount > 10

Re: How Do I Change Schema

2009-08-12 Thread Clinton Begin
M, pczurak wrote: > > I am using iBATIS 2.1 > > My question is how do I change Schema name for DB2 database? > > Schema.tablename > > ex: Select * from TEST.Payroll Payroll where amount > 100 > change to > Select * from PRODUCTION.Payroll Payroll where amount > 100 &

How Do I Change Schema

2009-08-12 Thread pczurak
I am using iBATIS 2.1 My question is how do I change Schema name for DB2 database? Schema.tablename ex: Select * from TEST.Payroll Payroll where amount > 100 change to Select * from PRODUCTION.Payroll Payroll where amount > 100 What file and what parameters/properties do I have to