Archives of the TeradataForum

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

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

<-- 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>>