Problem unloading Informix table to a text file using jdbc
hi,
I have been facing this problem since many days now.I need to unload a table of Informix database to a text file and i need to do it using a java application which will unload the data of a table to a text file every one hour,so i can not use dbaccess or any other tool.I need an application which itself will unload the data to text file automatically.
But when i use unload query using Jdbc,it comiles but gives error at run time.error is 'syntex error'.
please help me to use this query by jdbc.If any body needs the code sample i can provide it.i am using the jar driver file for infomix.
Thanks in advance,
javaseeker