topic Re: Script Questions in Operating System - HP-UX

Script Questions

rmueller58 — Thu, 05 Feb 2009 15:05:51 GMT

I need to populate a TEMPLATE prior to running with some particular items.. I have a script that creates a flat file in columnar data format.

177
55
5994
5996
5997
....
varN

TEMPLATE --
select * from table
-- INSERT WHERE CLAUSE HERE
where id in ( '177','55','5994','5995','5997','varN' )

any ideas appreciated

Re: Script Questions

Heironimus — Thu, 05 Feb 2009 16:04:53 GMT

Untested, but something like this should do what you want:

echo 'select * from table where id in ('$(sed -e "s/^\\|\$/'/g" test.txt | paste -d, -s)');'

Re: Script Questions

rmueller58 — Thu, 05 Feb 2009 16:41:32 GMT

Thank you..

STAGEDFILES=/mps-docs/mps-docs/mpsplustest/applicant/
cd $STAGEDFILES
rm -f /tmp/jac.txt
touch /tmp/jac.txt
for fn1 in `find -type f -mmin -360000 -print`
do
export fn=`echo $fn1| awk '{print substr($1,3,22)}'`
for appid in `echo $fn |awk -F_ '{print $2}'`
do
export distID=`echo $fn |awk -F_ '{print $1}'`
export appID=`echo $fn |awk -F_ '{print $2}'`
export docID=`echo $fn |awk -F_ '{print $3}'|cut -d. -f1`
export ext=`echo $fn |awk -F_ '{print $3}'|cut -d. -f2`

export ITERID=`echo 0`

echo $distID >> /tmp/jac.txt
done
done
sort /tmp/jac.txt |uniq > /tmp/jac1.txt
echo 'select * from table where id in ('$(sed -e "s/^\\|\$/'/g" /tmp/jac1.txt | paste -d, -s)');' > /tmp/TEMPLATE
more /tmp/TEMPLATE
cd

Re: Script Questions

rmueller58 — Thu, 05 Feb 2009 16:42:18 GMT

See post above