HP-UX下用shell生成sql语句

这样做的目的是置换sql语句中每月变化的检索条件。

脚本：mk_hpc_month_data_sql.sh：

# cat mk_hpc_month_data_sql.sh

#!/usr/bin/ksh
# This is for HPC users data

targ_dir=/space/mm/zhaochy
prog_dir=$targ_dir"/prog"
result_dir=$targ_dir"/result"
nowdate=`$prog_dir/date_sql.sh`
echo set heading off > $prog_dir/hpc_month_data.sql
echo set pagesize 0  >> $prog_dir/hpc_month_data.sql
echo set linesize 200 >> $prog_dir/hpc_month_data.sql
echo set trimout on >> $prog_dir/hpc_month_data.sql
echo set trimspool on >> $prog_dir/hpc_month_data.sql
echo set feedback off >> $prog_dir/hpc_month_data.sql
echo spool $result_dir"/"hpc_month_data.txt >> $prog_dir/hpc_month_data.sql
echo select owner,SUM"("filesize")/"1024"/"1024"/"1024 from BACKUP_ARCHIVE_DATA_LIST where backup_time LIKE "'""$nowdate""%'" group by owner";" >> $prog_dir/hpc_month_data.sql
echo spool off >> $prog_dir/hpc_month_data.sql
echo exit >> $prog_dir/hpc_month_data.sql

 

输出结果：
# cat hpc_month_data.sql

set heading off
set pagesize 0
set linesize 200
set trimout on
set trimspool on
set feedback off
spool /space/mm/zhaochy/result/hpc_month_data.txt
select owner,SUM(filesize)/1024/1024/1024 from BACKUP_ARCHIVE_DATA_LIST where backup_time LIKE '201007%' group by owner;
spool off
exit