UNIX for Dummies Questions & Answers

EOF} | while read line

EOF
} | while read line

set head off
spool $filename
select .......
spool off
exit

$DCITS_SQL << EOF
SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON VERIFY OFF TIMING OFF TERMOUT OFF
spool $tmpfile
select a.FIN,a.STAFF_NAME_X,b.FIN,b.DEPT_C from ci_5day_staff a, ci_cits_consol_dtls b where a.FIN=b.FIN;
spool off
exit
EOF

while read $tmpfile

do
	if [ "$tmpfile" ]#check if line is not null
	then 
		#if line not null, parse the line into words/variables
		set $tmpfile #set the line to positional variables, in this case is $1 and $2
		fin ="$1" #staff fin number
		name="$2" #name of staff
		gway="$3" 
		echo "$fin,$name,$gway" >> $final

fi
done

while read line
do
	if [ "$line" ]#check if line is not null
	then 
		#if line not null, parse the line into words/variables
		set $line  #set the line to positional variables, in this case is $1 and $2
		fin ="$1" #staff fin number
		name="$2" #name of staff
		gway="$3" 
		echo "$fin,$name,$gway" >> $final

fi
done <$tmpfile

tmpfile=/some/dir/tmpfile