How to include a command in shell script?

[root@server01 ~]# dbc "delete from alert;"
DELETE 10
[root@server01 ~]#

However, the script created below generates an error that command does not exits. Can any one please exist.

script.sh:
#!/bin/sh
dbc "delete from alert;" >>$TASKLOGFILE

./script.sh: line 38: dbc: command not found

can any one please assist.

Thanks

you will need to include the path information

#!/bin/sh
/path/to/dbc "delete from alert;" >>$TASKLOGFILE

---------- Post updated at 03:22 PM ---------- Previous update was at 03:18 PM ----------

If you don't know the path to the dbc program, you can try

find / -name dbc -print
which dbc

Excellent and thank you very much.