This is a follow-up to this dbisqlc question:
Using the redirection operator &> in a batch
seems to work only with a command and not with a command file. At least some tests with SA 10.0.1.4181 seem to imply that:
Is this a known limitation with dbisqlc?
When dbisqlc has just one command line argument, it assumes it is a filename. When there are multiple, it assumes it is a SQL statement. To get the behaviour you are looking for, change it into a SQL statement by using a dbisql 'READ' statement explicitly:
dbisqlc read command_file ">&" output.txt
answered 13 Mar '11, 07:42