Hello,

We are using Sql Anywhere 9.0.2, build 3221 on NT, WIN2000
and XP platforms.
Can anybody explain the difference between dbisql, dbisqlc
and dbisqlg, not only in terms of usage ( interactive or
command line/batch mode ) , but functionality too.
Apparently some scripts we had in 5.5.04 which included:

call this_proc() >>#c:\result.txt;
resume all;

work if script executed from the command line with dbisqlc
and do not work if executed with dbisql, because of 2
problems:

1. The procedure's result set is not written to the file.
2. ‘Resume all’ gives syntax error.

Thank you in advance,
Roumiana Valtcheva
Propharm, Toronto

dbisqlg - Java version
dbisqlc - C version
dbisql - is an alias for dbisqlg

and yes, dbisqlG and dbisqlC have some differences. In BOL, in the chapter
ASA Programming Guide
Deploying Databases and Applications
Deploying administration tools
is a passage:
--------
Deploying Interactive SQL
If your customer application is running on machines with limited resources,
you may want to deploy dbisqlc.exe instead of Interactive SQL. However,
dbisqlc is a limited application. It does not contain all the features of
Interactive SQL and compatibility between the two is not guaranteed.
--------

In short, for development and everyday life I prefer dbisqlG, for batch
work - dbisqlC.



<Roumiana Valtcheva> wrote



Hello,

We are using Sql Anywhere 9.0.2, build 3221 on NT, WIN2000
and XP platforms.
Can anybody explain the difference between dbisql, dbisqlc
and dbisqlg, not only in terms of usage ( interactive or
command line/batch mode ) , but functionality too.
Apparently some scripts we had in 5.5.04 which included:

call this_proc() >>#c:\result.txt;
resume all;

work if script executed from the command line with dbisqlc
and do not work if executed with dbisql, because of 2
problems:

1. The procedure's result set is not written to the file.
2. 'Resume all' gives syntax error.

Thank you in advance,
Roumiana Valtcheva
Propharm, Toronto

dbisqlc is the *old* C version of the interactive SQL utility whose
features and functions have been superseded by the Java version. The
old utility is preserved (with the V6 functionality) because people find
it useful for all sorts of reasons.

dbisql is a "shell" that calls dbisqlg which is the java version of
interactive sql

The two utilities have a number of differences. These are two of them.
There are others.

HTH

/steve
Stephen Rice
Technical Services Manager
iAnywhere (a Sybase Company)
email: srice (AT) ianywhere (DOT) com


Roumiana Valtcheva wrote: