Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 May 2006 @ 21:16:20 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Bteq with .Repeat * Using
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, May 17, 2006 17:07 -->

Hi Everybody

I'm getting an syntax error on username try to loop through a list of users with the following code: I'd appreciate any help that I can get. Thanks

     .IMPORT VARTEXT FILE=/home1/test/work.d/users

     .REPEAT *
       USING username  (VARCHAR (30))

     create user :username from DBS_users
     as
      perm                     = 0
     ,temporary            = 0
     ,password             = temp1234
     ,default database = object_db
     ,account                = '\$L1\$'
     ,spool                    = 20000000000
     ,profile                   = default_DBS_profile
     ,default role           = DBSUser
     ,no fallback
     ,no before journal
     ,no after journal
     ;


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016