i read the variable ph from file and i wanna to print it in awk.
example
ph=`cat tmpbatch`
tail h.txt|grep "| |"|awk -F"|" '{ print "@unpdx.sql",$5 }'"$ph"
i try this but it does not work

try using the -v switch when passing variables into Awk

awk -v foo=$ph ......

Here is a link Using Shell Variables in Awk

i try it but it does not work it give me error
suppose "ph" is a variable were calculated before
ph= bla bla bla
and i have an input file as
aaa|1234
bbb|6325
ccc|7454
aaa|5467

i wanna to print in out put file second field of the line that contian aaa and at the end of each line the value of the variable.
so the output will be

1234 bla bla bla
5467 bla bla bla

and thnx in advance

For something like this, i would think you would want to use an egrep or grep expression. I dont think (or dont know how) to use a variable passed into Awk as a pattern to search. But you can do something like this, thought it may not run too fast.

awk -v ph=bbb 'BEGIN{ FS="|" ; OFS=" " } {if($1 ==ph) {print $2, $1}} ' file

If I read the question right....

awk -v ph="bla bla bla" 'BEGIN{ FS="|";OFS=" "} /aaa/{print $2, ph}' file

i try the folowing code "just for testing" i get the following error
operate >tail ACCL.txt|awk -v ph="bla bla bla" '{print $2, ph}'
awk: syntax error near line 1
awk: bailing out near line 1
and does this work if i ph calculated by exprestion as
ph = `cat file`

What system are you using? Run "uname -a" and post the results.