I’m using Robot Framework in automations. Now I’m adding SQL Server scripts. In order to facilitate, I would like to make a print of my query (select) to display in the console. How do I do? I tried with the following way, but without success: and The latter prints to the console, but the query se…
Tag: automation
How to automate a sql script in snowflake
I have a SQL script that transforms data for various tables in snowflake. I need to run this SQL code daily and I want to automate it somehow. I thought I could automate the SQL with ‘tasks’ in snowflake but ‘tasks’ are unable to run more than one single SQL statement and my code conta…
SQL Select Statement – Automation Anywhere
I am trying to write an SQL select statement where i only extract two columns from a csv which has been connected as a CSV. The select statement query i am using is: Which extracts all data in the table as expected, I wish to only extract data in columns with headers: The below line of code throws a syntax
Dynamic update query for multiple columns using spring MVC
I am having a JSON data as shown below: I need a query to be executed and should be in the below form I am using Spring MVC for processing this and the code I wrote is as follows. It is not complete. It would be very much helpful if someone could help me out here. Thanks in advance. Answer
How to write a program to automatically download a file from email
I have an email account (like gmail or something) that gets a daily email with a file attached to it that has some data in it. Is there a way to have a program check the email everyday, say at midnight or something, download that file, and store the contents into a SQL database? I’m familiar with Java, …