Hi Pals,

         I am trying to unload the values in the sql anywhere table

   to a text file by using this command

         select * from tablename ># c:\testfile.txt

         i am writing this command in triggers, if i save the

  trigger it is showing an error, so how can i execute this statement

  in sql anywhere

Check with the isql utility available to that version. It is command prompt utility that can take input parameter and write output to a txt file passed as output paramater.

I believe it should look something like

isql -Sserver -Uusername -Ppassword -Iinputfilename -Ooutputfilename

inputfile should contain the select statement followe bu GO keyword

outputfile would be created later.

Cheers!

_________________________
- Vijay G
Strive for Perfection