SQL Query and IF/Then

[Torgo]

Hi I just have a situation where I need to have Automation Anywhere connect to an Oracle DB and look at a specific table and if the SQL statement is = 1 then continue on with the script.

I have built the DB connection and I see where SQL can be executed but just not sure how to tie in the IF/THEN/ELSE statement. I see all of the possible selections under the IF/ELSE heading but not sure how to tie them to the SQL result.

[forumsupport]

Hello,

To access the result returned by the SQL Query, use the $Dataset Column$ System variable provided by Automation Anywhere. Use Loop for Each row in a SQL query dataset option to loop through all the rows of the SQL Query result. To access each column use $Dataset Column(index)$ for e.g. to get the first column use $Dataset Column(1)$. Then inside loop you can insert 'If Variable' command to check $Dataset Column(index)$ is equal to 1.

Text format of commands would appear something like this,

Execute SQL Statement: select * from tablename
Start Loop " Each row in a SQL query dataset of Session = Default"
If $Dataset Column(1)$ Equal To "1" Then
Comment: Please enter the conditional commands here.
End If
End Loop

Hope that helps.

[Torgo]

Thanks so much this worked great!