 |
 |
Archives of the TeradataForum
Message Posted: Wed, 22 Aug 2007 @ 11:11:58 GMT
| Subj: | | Re: How to run the Select SQL generated as a result of a SQL in Macro or Procedure |
| |
| From: | | Mogilevsky, Boris |
Hi,
I had a similar task and the way I have accomplished it - in two steps. First one - saves SQL operator in a flat file, second step - performs
an actual run of that file using RUN .file command. It works that way. I am on the road right now and can provide you an example later next week
if you need it. This can be done within the same SQL script.
Boris Mogilevsky
Teradata Professional Services
| |
