Hello,
I am using Aqua Data Studio 7.0.39 for my Database Stuff. I have a 20 SQL files(all contains sql statements, obviously).
I want to execute all rather than copy-paste contains for each.
Is there any way in Aqua to do such things.
Note: I am using Sybase
Thank you !!
Response
Niels Gron over 8 years ago
You can do this using FluidShell in Aqua Data Studio 15.0. Version 7.0 does not have a mechanism for this.
-Niels
Gordon Garrison over 7 years ago
Hi Niels,
I have ADS 16.0.9 and am trying to understand how to do this. Can you provide a sample script and instructions about how to schedule it?
I have a number of directories with SQL statements, each directory will insert into a specific table, so I need to be able to load them either one at a time or concatenated into the sqlbuffer, then execute.
Any help will be much appreciated.
Gordon
Niels Gron over 7 years ago
Here is documentation on how to do this …
How to use FluidShell :
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/246/FluidShell
Use the “source” command :
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/289/source
Run from command line and schedule for execution :
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/Automating-Data-Export/Automating-Data-Export#execute_runfluidscript_bunbled
Gordon Garrison over 7 years ago
Thank you. Can you tell me how to run from a Unix command line? I’m running OS X 10.11.
Niels Gron over 7 years ago
The scripts for the OSX .app package are in /Aqua Data Studio 16.0.8.app/Contents/Resources/
-Niels