Articles → AUTOMATION ANYWHERE → ‘Database’ command in automation anywhere 10.5

‘Database’ command in automation anywhere 10.5






Database command














Picture showing the database commands in automation anywhere

Click to Enlarge


Database Table




Picture showing the sample table with records

Click to Enlarge


Working with database













Connect to the database




Picture showing the Connect command for connecting to the database in automation anywhere

Click to Enlarge





Picture showing selecting the database engine

Click to Enlarge



Picture showing entering the database credentails

Click to Enlarge



Picture showing setting up the connection string in the connect command of the Database

Click to Enlarge


Execute SQL query and export data to CSV file.




Picture showing writing the select query in the SQL query command

Click to Enlarge


Disconnect




Picture showing the disconnect command for disconnecting the database connection

Click to Enlarge


Open the CSV file




Picture showing the open csv command for opening the CSV file

Click to Enlarge


Output


Picture showing the values of database tables inside the CSV file

Click to Enlarge

Posted By  -  Karan Gupta
 
Posted On  -  Sunday, September 30, 2018

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250