Search Results

Consider the following approach:
export fld2zero=TRUE
cat your_orig_file | while read fld1 fld2
do
if [ $fld2 -ne 0 ]
then
export fld2zero=FALSE
mailx -s "Subject goes here"...

I've a script of the following form calling a simple sql that counts the no of rows as based on some conditions. I want the count returned by the sql to get assigned to the variable sql_ret_val1....

Bulls eye .. Thanks a lot!

I'm calling an embedded sql from my shell script file. This sql does simple task of spooling out the contents of the table (see below my sample code) into a spool file that I specify. So far so good,...

Here is the formatted code... earlier due to some problem I was unable to post it in a proper way, so it was a little difficult to understand.

#!/bin/ksh

#Your test XYZ dir path goes here ...

Here you go ... #!/bin/ksh #Your test XYZ dir path goes here export TEST_DIR=/dir1/dir2/XYZ/ #ABC is your filenames file cat ABC | while read vFileName do if [ -r...

So basically if I understood you correctly, you have a file ABC that contains some file names. You want to check each line and see if that file name exists in XYZ folder, and if found there, then...

Is this date part of the filename, and in exactly the same format you listed? Or is this the file's date stamp that you are referring to here?

This is basically a symbolic name of the actual signal (that's an integar value). If you follow the link above in reply from amitranjansahu, you can see it gives you all the details.

The benefit...