Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I tried to execute SYSTEM statements like

SYSTEM 'notepad.exe';
or SYSTEM 'c:\Windows\write.exe';

in Interactive SQL. But none of them are sucessful on our machines. Interactive SQL is showing only

SYSTEM 'notpad.exe'; -- Microsoft Windows [Version 10.0.17763.437] -- (c) 2018 Microsoft Corporation. Alle Rechte vorbehalten. -- -- C:\WINDOWS\system32>

in the "History" tab. The "Results" tab stays empty and no new Window, running the executable, is opened. Executing Interactive SQL as Administrator is also not sucessful.

Many thanks

asked 30 Apr '19, 09:31

Robert%20Kratschmann's gravatar image

Robert Krats...
1166715
accept rate: 0%

1

I can reproduce this. You may be able to workaround the issue as follows:

SYSTEM '/c notepad.exe';

(30 Apr '19, 11:23) Chris Keating
Replies hidden

Thanks Chris

it works. No idea were the workaround is coming from...

(01 May '19, 11:39) Robert Krats...
2

This issue is being investigated as Engineering Case 819194 and should be addressed in a future software update.

(01 May '19, 15:45) Chris Keating
Replies hidden
1

The /c is a switch for default Windows ComSpec cmd.exe.

(01 May '19, 15:47) Chris Keating

Thanks Chris for Engineering Case 819194 and the comments on "/c"

(02 May '19, 06:01) Robert Krats...
1

This has been fixed and will be in an update 17.0 Build 5788 or newer.

(02 May '19, 18:14) Chris Keating
showing 3 of 6 show all flat view
Be the first one to answer this question!
toggle preview

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

Question tags:

×105

question asked: 30 Apr '19, 09:31

question was seen: 803 times

last updated: 02 May '19, 18:14