Documentation

SQLDumphandler function

This function s used to dump the resultant output of SQL query into a given excel file.

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SQLDUMPHANDLER function. Provide connName and queryName defined in settings, varData if there is any, file path, alias, and type.

Here, connName is defined under Settings > DB settings queryName is defined in Data > Manage SQL Scripts varData is given when you have to pass any data in the query filePath is excel file path where resultant query data will be dumped alias name is a variable name that will be used for further reference type defines the type of query like normal sql or stored procedure(SP).

If data is dumped successfully in the given file then it will return true in the variable defined in the Element key else it will return false. After completing this step it will look as below:

Was this page helpful?