Search Results

Hi,
The age of files is determined by the modification timestamps on the files not by timestamp in name. Please help.


Thanks,
Anil

Hi,
The file does not necesaarily have these names (anil_111 and anil_222). The first name 'anil' would come in parameter and remaining after '_' is timestamp.
I basically have to write a script...

Hi All,
I have a requirement where there are 2 files saved on unix directory with names anil_111 and anil_222. I just have to retain the latest file and delete the old file from the directory....

Thanks. It worked fine.

Now, there is one more problem that the output in mail is not properly arranged. I want database content to be in tabular format with column headings and center aligned. ...

Hi All,
I want to fetch records from Oracle DB table and send it in a mail to a set of users. i.e, I have a query which returns a set of records. I want to send mail with below content:



Hi...

Hi All,
I have a requirement where I have to pick csv files from another unix server by searching the list of files by their name and then copy to my server. Then I want to create their zip...

Hi,
I have a requirement where I have list of Excel files (with multiple tabs) placed in Unix directory.The naming convention is [Timestamp]_<Code> where <Code> is unique indentifier for each...

Hi,
I want to make Excel files password protected present in my Unix directory. I have a application which will basically invoke a shell script with a parameter passed. The purpose of shell script...

Thanks.It worked by using absolute path.

Hi,
I found below error :


wfedwd02$ cd /var/cron/log
ksh: /var/cron/log: not found.


What can be the reason for this?

Thanks,
Anil

Hi,

I have a shell script which needs to be run at 5 am everyday.I have crontab entry as "0 5 * * 0-6 /wfsdev1/app/edw/bin/HealthCh.sh" but this job is not running at scheduled time.What can be...

Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell...

Hi Tyler,
My extract file is fetching all the data from table but the problem is inspite of populating the rows from 1st line,it is getting inserted from 2nd row.Problem is that first line is...

Hi,
Is there any way to check the status of the mail sent or not.e.g

mail -s "Error Message" abc@xyz.com <aaa/bbb/data.txt

Can it return a status code which will confirm the delivery of mail...

Hi Tyler,
That worked.Thanks a ton.Can you just tell me the reason for having data in extract file from 2nd row not from first?

Thanks,
Anil

Hi Tyler,
Thanks for your reply.It really helped.But now i have another problem.
I am trying to send mail from shell script based on the exit status ($?) of the sqlplus. The code I am using is...

Hi,
I am calling a sql file script.sql from shell script and passing few parameters also as shown below:

sqlplus -S id/password @script.sql $param1 $param2

Now,In sql file I have to...

Hi,
I am trying to call sql script from ksh job with parameters.The parameters passed from ksh job will be used in SELECT query in sql file to SPOOL the data in extract file.My questions are:

1)...