Good Day! I am a user with limited permissions to our Teradata data warehouse. I have "Create Macro" permissions, but not "Create Procedure" permissions.
I have 30 queries I need to run sequentially to complete a process. These queries are stored in text (.sql) files and I have to run them individually and commit the results. I would like to be able to keep the queries in the text files and create a macro to go out, open, run and commit one at a time. I would like to keep the queries in the text files in order to make it easier to edit the queries.
This is an example of what I'm trying to do:
Create Macro mcr_example as ( run C:\query1.sql run C:\query2.sql run C:\query3.sql . . . );
The error I get is 3706: Syntax error: expected something between '(' and the word 'run'
Please tell me how I'm supposed to do this? I have looked at all the documentation our company has and the Internet and there is limited documentation on Teradata macros.