Differences Between Vortex, tsql and Metamorph API

While both the Vortex texis executable and tsql can execute SQL statements on the command line with similar syntaxes, there are subtle differences between the two. The texis executable is geared towards production servers, and restricts certain CPU-intensive operations. The tsql command is intended for temporary, administrative and debugging use, however for consistency with Vortex, in version 6 and later it has the same restrictions as Vortex on potentially high-load queries. (In version 5 and earlier, tsql was more lax; those legacy defaults can be restored by setting the SQL property querysettings to 'texis5defaults'; see here.) Some other differences in default settings are listed in the following table: