Shell Programming and Scripting

Hi Unix Experts,

Happy Morning to all !!

I am new to UNIX Shell Scripting and at my begineer level. To get acquainted to scripting, I am trying to create a script.

The details/requirements of my script was to create a script with month changing logic in it so that on every 6th Working day, it calls one more script that will process certain data.

I have just started to put my heads on it. Created a table excluding the public holidays so that 6th Working day is obtained correctly. Now I am struck in bringing the month changing logic in it. Here is my try.

Code:

e1=`sqlplus -s ${UNAME}/${UPSWD}@${ODS_CON} << EOF
set heading off;
set headsep off;
set underline off trims on;
select MONTH_TIME_KEY from time_dim  where date_start=trunc(sysdate);
EOF`

e2=0`echo $e1  | cut -c5-6`

cd /backups/micky/sample
cat /dev/null > SAMPLE_WORKLIST.lst
echo $e2 > SAMPLE_WORKLIST.lst

nohup extract_sample.sh &
exit

Can you please guide me on this. Many thanks.

Regards,
Micky

Your requirement is not so clear, but if you are looking for a way of advancing the month I suggest you to do it in DB.

You can use SQL function: ADD_MONTHS

Code:

select to_char(ADD_MONTHS(sysdate,1),'mon') from dual;
feb

Hi Bipinajith,

Thanks for your valuable suggestion.

I have a table (time_dim) which I have created in db where I can find what's the current working day. The script I am looking for is the one which will hit this table and pull out what's the current working day (say as 1 for Monday, 2 being Tuesday and so on..).

Your suggestion and help towards this is highly appreciated.

Use SQL to_char function to format the date as per your requirement.

E.g. If you need the full day name:

Code:

select to_char(sysdate,'day') from dual;
wednesday

Check Oracle docs for further reference. I hope this helps.