Shell Programming and Scripting

FILE=/path/to/the/infile
cat ${FILE} | sed 's/,/ /g' | while read ID
do
set${ID}

FILE=/path/to/infile
cat ${FILE} | sed 's/,/ /g' | while read ID
do
set${ID}

bteq <<-EOF
.logon $LOGON_STRING_DEV;

CREATE USER ${ID} FROM PROD_JOB_USERS  AS
       PERM=0,                            
       PASSWORD = ********             
       ACCOUNT='********'            
       DEFAULT DATABASE=PROD_DB;       
GRANT  DROP DATABASE ON ${ID} TO ALL PROD_DBA;                        
GRANT  DROP USER ON ${ID} TO ALL PROD_DBA;                        
GRANT  ALL ON ${ID} TO DBC WITH GRANT OPTION;
GRANT BATCH_JOB_ROLE TO ${ID};
MODIFY USER ${ID} AS DEFAULT ROLE = ALL;             

.quit;
EOF
done

NB203A,NB203B,NB203C,NB203D,NB203E,NB203F,NB203G,NB203H,NB203I,NB203J,NB203K,NB203L,NB203M,NB203N,NB203O,NB203P,NB203Q,NB203R,NB203S,NB203T,NB203U,NB203V,NB203W,NB203X,NB203Y,NB203Z

CMD_FILE=/tmp/a

echo ".logon $LOGON_STRING_DEV;" > $CMD_FILE
cat ${FILE} | sed 's/,/ /g' | tr ' ' '\n' | while read ID
do

cat <<EOF >> $CMD_FILE
CREATE USER ${ID} FROM PROD_JOB_USERS  AS
       PERM=0,                            
       PASSWORD = ********             
       ACCOUNT='********'            
       DEFAULT DATABASE=PROD_DB;       
GRANT  DROP DATABASE ON ${ID} TO ALL PROD_DBA;                        
GRANT  DROP USER ON ${ID} TO ALL PROD_DBA;                        
GRANT  ALL ON ${ID} TO DBC WITH GRANT OPTION;
GRANT BATCH_JOB_ROLE TO ${ID};
MODIFY USER ${ID} AS DEFAULT ROLE = ALL;             
EOF

done

echo ".quit" >> $CMD_FILE

cat $CMD_FILE | bteq

for mEach in $(tr ',' '\n' < ${FILE}); do
  echo "Each <${mEach}>"
done