Page History
...
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
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#printIn] ,[ println
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#printIn] ,[ variable
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#variable] ,[ executeCallableQuery
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#executeCallableQuery] ,[ sendMail
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#sendMail] ,[ saveResults
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#saveResults] ,[ saveLastResult
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#saveResults] ,[ setResultSettings
...
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation20.6/page/196/Aqua-Commands#setResultSettings] , and[ setPivotResultSettings
...
| Wiki Markup |
|---|
*.println \[.print\]* |
...
| Wiki Markup |
|---|
_Syntax:{_}.println \{ | 'text value' \}\[, ... n\] |
...
| Wiki Markup |
|---|
_Syntax:{_}.variable , datatype \[, value\] |
...
| Wiki Markup |
|---|
_Syntax:{_}.executeCallableQuery 'parameter_name\[, ... n\]',\{ CALL ( ? \{ , ? ... \} ) \}or ...\{ ? = CALL ( ? \{ , ? ... \} ) \} |
...
| Wiki Markup |
|---|
.setResultSettings 'Index=,Title=,CategoryFields=,where a field looks like "\[Field Name\] \{List of Aggregate Functions\}SeriesFields=,SortBy=,SortOrder=,ShowTitle=,TopCount=, |
...
| Wiki Markup |
|---|
_Example:{_}.setResultSettings 'Index=1,Chart=column,RotX=325,RotY=53,RotZ=0,Zoom=50.0,ScaleData=true,ShowChart=true,ShowLegend=true,ShowTitle=false,ColFields="\[ShipCountry\]",DataFields="\[Freight\]",Paging=true,ShowTopCount=false,Split=0.35460994' |
...
| Wiki Markup |
|---|
.setPivotResultSettings 'Index=,ShowFields=,ShowTotal=,ShowSubTotal=,Title=,RowFields=,where a field looks like "\[Field Name\] \{List of Aggregate Functions\}ColFields=,DataFields=, |
...