Just a quick and short answer - There are several ways to unload as XML - among others
It's well documented in the SA 10 docs: SQL Anywhere® Server - SQL Usage > Using XML in the Database One easy way to select a whole table might be to use
|
If you want elements rather than attributes then try:
|