Shell Programming and Scripting

Hi Don,

I have tried the below script and no files moved to the directory "procedure"
even we have SQL files with string procedure.

path for head is /home/head

Code:

#!/bin/ksh
head=/home/head

mkdir -p "$head/procedure"
find "$head" \( -type d -name procedure -prune \) -o \
    \(	-type f -name '*.sql' -exec grep -q -F 'procedure' {} \; \
    	-exec mv {} "$head/procedure" \; \)

Please helpme.

Thanks

Did you get any diagnostic messages when you ran the script?

What operating system are you using?

Please show us the absolute pathname of an SQL file with a name ending in .sql that contains the string procedure. Show us the results from the commands:

Code:

ls -l path
grep procedure path

where path is the absolute pathname of one of the files that is not being moved by the script I suggested.

Hi don,

Please find the details as below

Version M-11/16/88i

Korn shell

We have sql files with the string procedure in the follwoing paths.

/head/sql
head/db


Thanks

---------- Post updated at 06:01 PM ---------- Previous update was at 04:07 PM ----------

Hi Don,

Can u please help me.

Thanks

I will be happy to help you if you provide the data I requested in post #9 in this thread. Without an example showing what is misbehaving, I can't help. The code I suggested works perfectly with the sample data I created on my system to test what I understood to be your requirements. (But, bumping up posts and thinking that I should be on call 24 hours/day to solve your problems is unacceptable.)

And, PLEASE tell us what operating system you're using! Version M-11/16/88i is not an operating system (although it might be a version number or a release number of an operating system). If you don't know what operating system you're using, please show us the output from the command:

Code:

uname -a

Hi Don,

This is the version
SunOS 5.10 Generic_147440-13 sun4u sparc SUNW

Please help me.

Thanks

In post #9 in this thread, I said:
Until you provide this information, there is nothing we can do to help!

Hi Don,

Code:

/head/sql>ls -l /head/sql

I got lot of files

Code:

/head/sql>grep procedure /head/sql

it's got giving any files.

Code:

/head/sql>grep procedure *.sql

It's giving files

Please help me.

Moderator's Comments:

PLEASE use CODE tags as required by forum rules for all sample input, all sample output, and all code segments. Continued refusal to properly format your posts may result in you being banned from this site.

Thanks