Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
827
|
Query analyzer scripts have support for 9 client side commands which allow you to execute a stored procedure with local variables bound to the parameters. See the AquaScripts and AquaProjects Section for much more complex scripting capabilities. This allows for the execution of procedures with OUT parameters. The commands include print, println, variable, executeCallableQuery, sendMail, saveResults, saveLastResult, setResultSettings, and setPivotResultSettings. Client side commands are identified by a dot at the beginning of the command line, and multiple commands can be executed within one batch statement. The schema browser contains object scripting for procedures and functions that include "EXECUTE" and "EXECUTE BIND". The script EXECUTE will generate the appropriate code needed to execute the object according to the database procedural language (ie. PL/SQL, T-SQL). The EXECUTE BIND will generate the appropriate Aqua Data Studio client side commands to execute the object. To easily generate the needed client commands to execute a procedure or function, you may browse in the schema browser to locate the procedure or function and right-click on the object to select "EXECUTE BIND" from the Script Object menus. Command support Query Analyzer scripts have support for client side commands ".sendMail", ".saveResults", ".saveLastResult", "setResultSettings", "setPivotResultSettings" which allow users to either save query results in an EXCEL, HTML, XML, or CSV document, or insert them into a table. The 'sendMail' command sends emails using the settings you specify and allows attachments. The 'saveResults' command saves the results of all of the queries in the window, while the 'saveLastResult' command only saves the result for the last query. The 'setResultSettings' command lays out how grid data will be presented. The 'setPivotResultSettings' command lays out how pivot grid data will be presented. Here is a combination example script using .setPivotResultSettings, .saveResults, and .sendMail which runs a query, takes data from that query, lays out, and generates a pivot grid result, saves the pivot grid results to two different Excel files, then emails a message with both Excel files as attachments.
.sendMail
Syntax: .sendMail 'host=smtp.gmail.com, port=465, ssl=true, authentication=true, user=, password=, from=me@mycompany.com, to=you@yourcompany.com, subject="Nice document attached", message="This will blow your sockets off\ncheck it out!", attachments="c:/abc.xls,c:/abc2.xls"'
.saveResults
Syntax:
Example:
Syntax:
Example:
Syntax:
Example:
GO
.setPivotResultSettings 'Index=1, GO
.saveResults 'format=excel, GO
.saveResults 'format=excel, GO
.sendMail 'host=smtp.gmail.com, GO |
|
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017