|
|
Archives of the TeradataForum
Message Posted: Wed, 06 Dec 2006 @ 20:43:54 GMT
Subj: | | Re: Problem using Repeat SQL |
|
From: | | Dieter Noeth |
Craig Ferry wrote:
| I am trying to run the following command using for a list of users via a script. I have tried both a REPEAT followed by the SQL and also
a REPEAT followed by a .OS command with no luck. Has anyone done something similar? | |
.export report file = bla.txt
.repeat *
select 'REVOKE LOGON ON ALL FROM ' || :User_Name || ';' (title '');
.export reset;
.run file = bla.txt;
.os rm bla.txt;
Dieter
| |