Unanswered: Help in sql query to include special characters
Hi i need help in including special characters in select query.
I am getting following error.As i have used following query:
queryString = "select name from tablename where (NAME like '"+ tempchild +"') with ur";
these special characters like &,_,'s giving error.please help me
Error Creating ResultSet Object
SQLCODE = -10
SQLSTATE = 42603
SQLErrMsg = [IBM][CLI Driver][DB2/AIX64] SQL0010N The string constant beginning with "') with ur" does not have an ending string delimiter. SQLSTATE=42603
at com.ibm.crm.rtuu.adapter.lcia.util.DBConnector.exe cuteDBQuery(DBConnector.java:120)
at com.ibm.crm.rtuu.adapter.refdata.RTUUOpportunityCa tegory.processOpportunityCategory(RTUUOpportunityC ategory.java:505)
at com.ibm.crm.rtuu.adapter.refdata.RTUUStartOpportun ityCategory.startOpportunityCategory(RTUUStartOppo rtunityCategory.java:57)
at com.ibm.crm.rtuu.adapter.utilities.twoMain.callOpp tyCategory(twoMain.java:117)
at com.ibm.crm.rtuu.adapter.utilities.twoMain.main(tw oMain.java:65)
com.ibm.crm.rtuu.adapter.lcia.exception.LciaDBExce ption: Error Creating ResultSet Object
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be