Search Results

find another way to extract the number,(count the exported file).
I think the problems here is that we are using db2 command,this is a IBM db2 cli command.when i change the "db2" to a "echo"...

when I put them one by one,first line will print "238"
second line print nothing
third line print Value of "NUMBER :"
but when I put them all together in a t1.sh,when i run this t1.sh,I get only...

only "Value of NUMBER :"

yes,both print nothing.

ALL seperate code your mentioned print the correct results.
the code:
db2 "export to ACTIONS.dat of del select * from ACTIONS" |grep "Number of rows exported" | awk '{print $5}'
gets following...

the space is deleted,but I am still can not assign the number to the variable x.
echo $x gives nothing. what can i do next?

I think the problems is that there is a space before number,how can I get rid of this space.thanks!

hi,thanks for reply,still can not make it work,here is several tests i make,hope it give you some idea of problems.
>x=123
>echo $x
123
>x=`db2 "export to ACTIONS.dat of del select * from...

first command is
db2 "export to ACTIONS.dat of del select * from ACTIONS"
it will created following message:
SQL3104N The Export utility is beginning to export data to file
"ACTIONS.dat".
...

hi,That works great,here is another issue.
The String been extract is comes from another shell command,like 'db2 "export blala"',
how can i combine your solution with first shell command.
thanks.

hi,I am new to shell script,I have String,like this:
Number of rows exported: 5321
the numbe at end could changing,how can I extract this number and assign it to a variable,then use it later in...