Search Results

Hi Pals..

I have a shell script Which is calling a .sql file.

#!/bin/ksh
sqlplus -s userID/password@DB_INSTANCE @Test.sql &
sqlplus -s userID/password@DB_INSTANCE << EOF
exit
EOF

Is...

Hey Pals..
Thanks for the help..
Each of the above replies helped me and also vgersh sent out a another reply to this thread..
I would post that as that might be helpfull to another one like me......

Hi Pals.

I have a file which is in the below format.

2007/10/15-12:04:24,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User1'...

Hi Vgersh,

I tried the code snippet you had given
I got an error When i tried to execute the same

cat.sh[6]: nawk: not found.

What do i need to do in order to run the script.

When i...

Thanks For the Gyaan ... :)
Actually The Timestamp is appended to the file by oracle at time of creation.
You are very much right Sir.
This forum rocks wrt quality...

Hi Guys

Thanks for all the pointers and help.
Got a simple and quick one liner answer.

ls -1rt Ack_to_MDS_* | xargs cat > new_file.xml

Regards
Srikanth GR

Hi Steve,

I have a smiliar requirement
But I was unable to figure out the sort command used .
If u can help me on that that will be great.


The are many files in a folder Which are of the...

Hi BlowTorch,

Thanks for you Help.

The File order is like this .
The Oldest File content needs to be concatenated at the begining and the latest ones at end.
It will be in the descending...

Hi Gurus, Experts,

I am facing a problem to concatenate all the files based on timeStamps.
The Problem is like this .

The are many files in a folder Which are of the below types
...

Hi Srikanth,

Suppose I need to capture a Value that is the result of the query
How do i do it.
Like

Select x from Tablex where y='56';
I need the value x to be stored in a variable for...

Hi folks
I have a snippet of code Which is like this

If ( ( A || B || C ) && D ) then
Do some thing....
elif exit
fi





How to rephrase this and use it so I dont get any Errors...

Hi All,

We now have a Log file which has time stamps of all the scripts ran. It has start
time and end time. I now have a requirement to send mail to the Admin after the script finishes running....

Hi Pals ..

Thanks for all the help and support...

Regards
Srikanth GR ...

Hi
Thanks for the helpfull code..

What needs to be done
If I need to exit from the script
It will be like If the Validation fails Exit with a return code 1
Else usual exit with return code...

I need to Validate the No Of "~"s occuring in each line to a variable which is passes in the command line to the shell script.

Basically the command line will be

count_Tilde.sh input_file.dat...

Hi

I have a small doubt in the above code.
How can i capture the NF variable out of that line
and use this variable for validation ?

Regards
Srikanth GR

Hi Folks,

I have a input file of the below format.


~~~OLKIT~OLKIT~1~~TBD~BEST PAGER & WIRELESS~4899 COMMON MARKET PLACE~~~DUBLIN~KS~43016~I~Y~DIRECT~D~~0
BPGRWRLS~~~OLKIT~OLKIT~1~~TBD~BEST...