Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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
      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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023