The character "\" is not valid

david_david · #1 (**permalink**) 02-06-08, 02:16

hi

I am in trouble with export to command.
using db2 v8.1

its working fine in controlCenter->commandEditor

query is:

EXPORT TO F:\exportDB2\CFG_CADCONTEXT.ixf OF IXF MESSAGES log SELECT * FROM ADMIN.CFG_CADCONTEXT;

but when i execute in my java program , exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0007N The character "\" following "EXPORT TO F:" is not valid. SQLSTATE=42601

java code is:

String FOLDER="F:\\exportDB2\\";
String SCHEMA="ADMIN";
String tname="CFG_CADCONTEXT";
String query = "EXPORT TO "+FOLDER+""+tname+".ixf OF IXF MESSAGES log " +
"SELECT * FROM "+SCHEMA+"."+tname+"";

st.execute(query);