How do I automate the process of exporting data from database tables -
03-04-2010
, 02:41 PM
Hi, I am currently using Interactive SQL version 11.0.1 to run my
select statement against a SQL anywhere 10 database, then use the
export menu option in the Interactive SQL application to export the
data to a csv file manually. Is there a way to do this task
automatically? Maybe with a script? I read the documentation and I
know there is a dbunload command. But I do not know how to connect to
the remote database and executive my select statement. Please help.
Thank you.
Yong |