Shell Programming and Scripting

Hi All,

I am new to shell scripting required some help in passing the parameter value to the shell script.

I am writing a shell script, in the script I have created two functions as below.

first function

get_trend_ids () {

Here I am connecting to the database and getting all the trend id's in a trend_ids.txt file, this file will be stored in /root/edw/trend/srcfiles

}

second function

Load_trend_data () {


Here I am connecting to the teradata database and calling a teradata store procedure as below

EXEC SP_TREND_DATA_LOAD( trend_ids) }


Now the file which I have generated using the first function has to be used in the place of trend_ids which is highlighted with red color below.the procedure has to execute for all the values which are present in the trend_id.txt


EXEC SP_TREND_DATA_LOAD( trend_ids) }

I tried using while read loop here , but I don't don't know how to use that here.


Can anyone tell me the above part, how can I code in the shell script.


Trend_ids's will have the below values

1
2
3
44
66666
5555


Thx,
Shruthi

Think of it more as a script generating, text processing task.

Code:

while read tid
do
 echo "EXEC SP_TREND_DATA_LOAD($tid)"
done </root/edw/trend/srcfiles | . . . .

Thanks for the reply...

I tried the below while loop in my code.

Code:

while read get_trend_ids 
do  
    echo "EXEC SP_TREND_DATA_LOAD($tid)" 
done /root/edw/trend/srcfiles

My script is getting executed but it's not picking any values from the txt file.

can you please have a look and tell me where I am doing it wrong.


Thx,
Shruthi

Try changing

Code:

done /root/edw/trend/srcfiles

to

Code:

done < /root/edw/trend/srcfiles

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums