Search Results

yes, i understand .....in script A, the creation of table tempa will take 1 to 10min ....anyways.... thank you :)

sed -e 's|//||g' -e '/^$/d' FILE1

try using below set in SQL query .....


set pagesize 0
set lines 1000
set echo on
set heading on



(cat body; uuencode attch1 attch1; uuencode attch2 attch2; ) | mailx -m -s...

your question is not clear, r u trying to to search string hardware in given input file XXX_result.txt ? or just want to display everything in file XXX_result.txt
?

scriptA.sh
touch letsgotempfile_$(date +'%Y%m%d%')



$ more scriptB.sh
#!/usr/bin/ksh
log_path='/data/mig04/logs'
timestamp=$(date +'%Y%m%d%')
while [ ! -f /letsgotempfile_$(date...

i have script A and script B, both scripts have to run in parallel, my requirement is script A create table temp1, post creating it will run fr 4 hrs , script B has to start 0nly after creation of...

#!/bin/sh

echo "please enter the directory name.........."
read dir #yu have t enter dirrectory as DUSTBIN


if ! [ -d "$dir" ]
then
echo " $dir is not...

Hi Mr complex,

could you please let me know how it works ?


awk '!a[$1]++' infile

i am using HP-UX OS......

delete logs older than 60 days

find -mtime +60 | grep -i '.*log' | xargs rm

-mtime is nt available in HP-UX, pls tell me other option ?

find list of files modified for a given day ?

if i have 10 files in my directory, i have modified only 5 ... how to display only modified files ?

file=$(ls -ltr | tail -1) it does not give exact filename, disaplays other information .....file=$(ls -ltr | tail -1 | awk '{print $NF}') will give the latest modified file name.

CMF_COMP_ELEM_GSM2_B71.WORLD_20121114130908.log 107496444 rows inserted into ALL_S1_CMF_COMP_ELEM.
CMF_COMP_ELEM_GSM3_B71.WORLD_20121114130908.log 110729006 rows inserted into...

@bipin ......you are awesome ....... thanks

thanks subramanian :)

if i want to attach 2 text files then ?

i have to attach the 'body in the email' along with attachment below code is throwing errors, how can i do it ?

here body file contains message, it should display in email, please help

i am...

print lines between <pattern1> and <pattern2>.

assuming pattren 1 is 'select'
pattern 2 is 'from'

a crude way of printing the lines between pattern1 & pattern2


v1=$(grep -n 'select' ...

@Don , thanks a ton

@pamu, its working


is * does not take . ?

why we need to have *.*. ?

i have text file as below


CMF_COMP_ELEM_ GSM2_B71.WORLD_20121114130908.log 107496444 rows inserted into ALL_S1_CMF_COMP_ELEM.
CMF_COMP_ELEM_ GSM3_B71.WORLD_20121114130908.log 110729006...

@bala

cat t1

CMF_COM_ELEMENT_log 68715079 rows inserted into ALL_S1_CMF_COM_ELEMENT.
CMF_COM_ELEMENT1_log 68715 rows inserted into ALL_S1_CMF_COM_ELEMENT1.
CMF_COM_ELEMENT2_log 68715...

lets say if i have file as below

cat sample.txt
satish
/rakesh/
sandhya
/sandeep/


i have to replace /rakesh/ with rakesh, how can i do it with sed, i tried below code but its throwing...

Hello friends/'unix experts',

i have a file as below


cat sample.txt

satish
/rakesh/
sandhya
/sandeep/


i have to replace /rakesh/ with rakesh, how can i do it with sed, i tried...

@cts

could you please explain the below code


sed 's/ / "/2'


need to know the significance of 2, will it look for 2ns field with delimiter

i tried its throwing error, marked in red


#!/bin/sh
echo " Enter your choice to continue y/Y OR n/N to quit "
read A
if [ [ "$A" = "y" || "$A" = "Y" ] ]
then
echo " user requested to...

if i have a file as below, how can i get below output, by using awk


cat t1

CMF_COM_ELEMENT_log 68715079 rows inserted into ALL_S1_CMF_COM_ELEMENT.
CMF_COM_ELEMENT1_log 68715 rows...