Search Results

I executed the script and it worked fine , only one modification needed..

It prints :

Query=SYS.TesT8:"where not ( ( OUY LIKE 'H%') or (OUY LIKE 'A%') or (OUY LIKE 'Z%') or (OUY LIKE 'OP%') or...

Thanks for your reply.. The above condition worked for Tables..

and for Queries i think i need to explain a little bit..


like this i have complex queries written in each and every statement.....

I am currently struck with one shell script which i am not aware of how to create it..

I have file with the following contents,
export SYS.Test1;
export SYS.Test2;
export SYS.Test3;
export...

Thanks for your reply :


if the file name is xyz_xyzxyz_xyz_2009565213_20085778992_.lst.gzip

can you please let me know can you you trim the numeric values

output should be :

...

Thanks for your reply,


I am not actually concerned whether the file is present or not , if it is not able to get the file , it has to just skip and move on ,


but the script which i gave...

hello ,


I am working on a FTP script which navigates to specific directory and pulls the file


Issue which i am facing ::
----------------------------

i) When there is a file it pulls...

Thanks for your reply,,

it displays the file name , but i need to have the new file name in the directory instead of the one which has the timestamp

xyz_20091108_22142365.gzip should be...

Hello

I am currently working on a shell script which actually needs to pull some file

from a server ,


The filenames will have the extension with date/time stamp , i need to trim that...

Yeah it is a question !! i tried to run the above shell script .. It was able to Print " No Values Present "

But here are the issues ::

1)It is not able to break the loop once it prints "No...

Thanks for the reply !!

Mail option didn't work .. lets say i have some other shell code written next to the line of " No Values present " .. whether this shell script should also comeout . i...

Just to be Clear ..

If "No values are found " then the Program should exit out and send an email that no Values are found !!!

Thanks

The above problem has been solved .. once the Program finds that there is no values found .. it has to exit out from the shell and send an email alert As No key values found .. else it proceeds with...

Thanks .. I have few more doubts in this shell script ...

1) If i have a line say for example :: I have stored the output in a file

kkkkbbbb1476ysy <jyhshsh@ffassd.com> [expires: 2008-03-28]...

Hi .. i tried using this .. but couldnot analyze th code .. it gives an error ..

syntax error at -e line 9, near "print
"
Semicolon seems to be missing at -e line 10.
syntax error at -e line...

Thanks for the reply .. Can you also tell me , when there are no days in the range of 30 days .. it should print " no values are present

i am not sure of the GNU version of dates here .. i am a new to this platform

i am using sun solaris and Using ksh (Korn shell)

unix version :: SunOS 5.8

Shell type :: Korn

Thanks for youe help!!

but it giving sed command grabled .. can you please take a look of the below error !! Thanks again


date: illegal option -- -
date: illegal option -- t
date: illegal...

Thanks for your replies .. but it didnot work !!

This is my input

I have a file a.txt which has the values which is YYYY-MM-DD format

[expires: 2008-03-29]
[expires: 2008-04-26]
[expires:...

Hi .. i am not sure of the code .. Please help me on this as i am new to this shell scripting

Thanks

Sorry .. i was not clear , these values are present in a file .. and i have to compare it with current date in unix box and give a result which is one day
more , and if there are no entries in the...

I am writing an shell script , which reads a file with contents

Example :: (( This Format is yyyy-MM-DD))

2008-05-16
2008-05-17
2008-05-18
2008-05-19
2008-05-20
2008-05-21

when i run...

I think i am all set with the above script , its working fine

Just an addon to it can we bring the output like this ::


Name&email Expires
=========== ...

Thanks for the reply

Not always there will be two lines ..

There will be pub and sub and also in some lines there will be a uid as well

also .. with that ouput i have to give it like this
...

Hi i tried with a sample file which has the list of keys

it gave me this output [expires: 2008-05-16]

but the require output is unicorn01516008 <uniccrn1@fund.com> [expires: 2008-05-16]
...