Automation Anywhere - Database Command

Automation Anywhere - Database Command

Automation Anywhere

Database Command

This command is use to integrate with database.

Sub-commands

• Connect - This command is use to connect to Database by providing session name and connection string.
  
  

  

  Connect Command

• Disconnect - This command is use to disconnect from a database by providing session name.

  

  Disconnect Command

• SQL Query - This command is use to Select data from the database.
• Insert/Update/Delete - This command is use to do operation in database like Insert/Update/Delete.
• Run Stored Procedure - This command is use to execute a stored procedure from the automated task.

Components of SQL Query :

• Session Name - Specify the name of session.
• Enter Select Query - Specify the SQL Query to get the data from the database.
• Maximum number of records to fetch - Specify the number of Rows want to fetch from the database.
• Timeout for the Query - Specify the timeout to get the data from the database.
• Export data to CSV - Select this option and specify the filename with path, if you want to get data into a file.

  

  SQL Query Command

Components of Insert/Update/Delete:

• Session Name - Specify the name of session.
• Enter Insert/Update/Delete Statement - Specify the Insert/Update/Delete SQL statement to do operation in database.
• Timeout for the Query - Specify the timeout to do operation from the database.

  

  Insert/Update/Delete Command

Components of Run Stored Procedure:

• Session Name - Specify the name of session.
• Procedure Name - Specify the procedure name you want to execute.
• Add Parameter - Select this option if procedure contains parameter. Specify the name of the Parameter, parameter's value and parameter type.
• Export data to CSV - Select this option and specify the filename with path, if you want to export data from the Stored Procedure.
• Timeout for the Query - Specify the timeout to run SP.

  

  Run Stored Procedure Command

---

Share: