Search Results

Guys,
I've a xlsx file containing pivot tables and my job is to FTP it from one Linux terminal to another.

I use the script below :
ftp -in xxxx > /ftp.log 2>&1 <<EOT
user xxx yyyy
binary
cd...

Guys,
I've been trying to attach & email all txt files from my directory using the shell script below:

#!/usr/bin/sh...

Guys,
My log files stored in the date format format below(log_20080714072942):

TIMESTAMP=`date +%Y%m%d%H%M%S`
LOG=/log/log_${TIMESTAMP}.log

I'm looking for a shell script which deletes all...

I've been trying to find out the following parameters of our Unix box:
==>OS version
==> patch level
and the following kernel parameters
=>maxfiles_lim
=>maxvgs
=>nproc
=>msgmni ...

Thanks everyone who offered a helping hand to solve my problem.

I used TO_CHAR function and finally it works..
SELECT MAX(CTRL_PERD) FROM PROD WHERE CODE=TO_CHAR(123);

Thanks again!!!!...

mm..Intriguing...
My script invokes tables across a database link...
Could that perhaps be the reason for the error?

[pre]SQL> desc prod
Name Null? Type
----------------------------------------- -------- ----------------------------
CTRL_PERD ...

.Thanks for your reply.
They are perfectly valid in my database.
I get the result when I execute the same query in SQL plux..
Intruiging...

Guys,
Please suggest me what's wrong with this script?


#!/usr/bin/sh
##############################################################################
# Author : Bhagat Singh
#
#
# Date ...

You mean my rule file should look like this?

INTERVAL 60
#The following command watches for stop file to terminate the job for the day.
ON_FILEWATCH ${HLD}/CMD/cmd_mm.stop CREATE 0 0 30 0400 31...

Hi everyone,
Please find the script for Filewatcher rule file,which does the simple job of moving the files whenever it dectects to another directory.And whenever it detects the cmd_mm.stop file,it...

Guys,
My requirement is to spool the resultset of an SQL query to a text file.And one of the select columns of the SQL query is obtained dyamically from the result set of 2 other SQL queries.

And...

I've a text file whose content needs to be changed every month as below:
For July the content should be below:
FACT_AMT=FACT_AMT_16
for August
FACT_AMT=FACT_AMT_17-FACT_AMT_16
for September...

I'm using sh.

line1:
A,P,CMD,21-SEP-06,2006
and line1_m:
A,P,CMD,21-SEP-06,2006,2814

Guidance plz.

With
sed -e "s/${line1}/${line1_m}/g" prod_hier_1234.txt > test.txt
.....
It throws the error message "sed: Function s/ cannot be parsed."..
Oooops..

Guys,
I've a problem in the "sed" command used in my shellscripts

This is the problamatic line in my shell script:
sed -e 's/${line1}/${line1_m}/g' prod_hier_1234.txt > test.txt
It doesn't do...

Hi Guys,
I'm looking for a slightly modified script this time...
ie.Query Oracle database table and populate the result set of the query in a text file.The column values should be seperat
I also...

Thanks both of you!!!
That was very helpful!!
Appreciate your guidance

Regards,
Bhagat

Hi Guys,
I'm new to this forum as well as to UNIX shell scripting.
I'm looking for a shellscript to query an Oracle database table and populate the result set of the query in a text file.
Could...