Solaris

Hi All,

can any one help me regarding the following sample code ..,
i just want to repeat the sql query 7 times as mentioned below ..,but it's getting failed.

selet*REF_DATE='03-MAY-08'*
select*REF_DATE='04-MAY-08'*
select REF_DATE='05-MAY-08'*
--
--
select*REF_DATE='10-MAY-08'*


SQL_FILE=sqlfile.sql
COUNTER=3

echo "SET NEWPAGE 0
SET SPACE 0
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TERMOUT OFF
SET FLUSH OFF
SET TRIMS ON
SET VERIFY OFF
SET MAYKUP HTML OFF SPOOL OFF
set linesize 250 " > $SQL_FILE


while [ $COUNTER <= 10 ]; do

echo "select 'TIMESTAMP, CALLING_NUMBER, CALLED_NUMBER, DURATION(MINUTES), TRUNKIN, TRUNKOUT, VIOLATIONFLAG,CIRCLE,POICODE,INOPERATOR,SERVICE,RATE' from dual;

SELECT RATED35||','||RATED36||','||RATED37||','||round((RATED23/60),2)||','||RATED17||','||RATED18||','||RATED54||','||RATED11||','||RATED46||','||RATED1||',
'||RATED2||','||trim(round(rated12,2)) FROM TRAFFIC WHERE REF_DATE='{$COUNTER}-MAY-08' AND FILE_ID IN ( (SELECT fileid FROM FILE_DISTR WHERE fileid >= 121423
8 AND fileid <= 1239493 AND SUBSTR ( SUBSTR (filename, INSTR (filename, '_', 1, 5) + 1),1,INSTR ( SUBSTR (filename,INSTR (filename, '_', 1, 5) + 1),'_',1,1)-
1) IN ( SELECT DISTINCT mod_code FROM file_recon WHERE ref_date = '31-may-08' AND POI_CODE IN ('DVGEWD','HBOCBT','HSNOCB','KLROCB','KLROCB','MCROCB','MDYOCB
','MRTAX','MRTAX','MYOCB','MYOCB','TMROCB','TMROCB','CENTAX','CENTAX','CENTAX','WMSOCB','WMSOCB','WM SOCB','WMSOCB','WMSOCB')))) and rated20 like '%USC%'; " >> $SQL_FILE

let COUNTER=COUNTER+1
done

echo "spool off
exit" >> $SQL_FILE

highlight the section that is programming, and click on the # sign (next to the < > symbol).

This maintains the spacing and indenting - making it possible to read and follow your loops, etc..

After an post has been done, you can click EDIT then ADVANCED EDIT to accomplish this.