In SQLA17 where has the command line interface gone for DBISQL?

In SQLA10 when running dbisql.exe with the -d1 parameter and passing it a script, it used to display the command line window showing statement execution. Now, with SQLA17, running the same command, the full GUI is displayed and requires user interaction to close it when the script is complete. Adding the -nogui switch removes the GUI and allows the script to execute without user interaction. However, it is no longer possible to watch the execution in the command line window. I have looked at all the available switches for dbisql.exe, but cannot work out how to run with the command line window showing execution. Is this still possible, or has this ability been removed?

asked 05 Sep '16, 10:54

robertwigley
266●11●13●21
accept rate: 80%

edited 05 Sep '16, 11:35

flat view

One Answer:

active answers oldest answers newest answers popular answers

You should use dbisql.com.

It has the -d1 switch you are searching.

For Windows, there are two executables:

Batch scripts should call dbisql or dbisql.com, not dbisql.exe. The dbisql.com executable is linked as a console application.
The dbisql.exe executable is linked as a windowed application and does not block the command shell from which it was started. If dbisql.exe is run from a batch file, you won't see any output sent to the standard output or standard error files.

HTH

permanent link

answered 06 Sep '16, 02:27

Thomas Dueme...
2.7k●28●38●64
accept rate: 17%

Just for the record:

Usually you can also use the "classic" v17 dbisqlc.exe utility (now deprecated) with its own logging facilities...

(06 Sep '16, 02:57) Volker Barth

Super! That is what I was after. Did not realise you could use dbisql.com the same way. This now behaves the way that dbisql.exe did in SQLA10. Can't use dbisqlc.exe as it does not take the @data parameter and also don't want to use it as it's depreciated.

(06 Sep '16, 04:58) robertwigley

Replies hidden

Understood - so the @data parameter and the "newer" options of the INPUT/OUTPUT commands are contra-indications for my "Usually you can also use dbisqlc.exe" statement:)

As to the deprecated tag - yes, I'm aware of that (dbisqlc had entered "deprecated state" in v11.0.1 AFAIK and had a "limited functionality" warning with v10 and below) - but the dear SQL Anywhere engineers are well-known to still use that utitily themselves, so I'd not expect a soon discontinuation here...

(06 Sep '16, 06:19) Volker Barth

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-17 ×222
dbisql ×103
windows ×47
command-line ×5

question asked: 05 Sep '16, 10:54

question was seen: 2,286 times

last updated: 06 Sep '16, 06:20

SAP SQL Anywhere

In SQLA17 where has the command line interface gone for DBISQL?

Follow this question

Related questions