Re: How to use the character dollar ($) in a command file ?

The $ sign is being interpretted by the shell script interpreter as the start of a shell variable and is substituting nothing in place of whatever followed the $ sign up to a space. For example,

        select * from ops$frank.emp;

would be interpreted as

        select * from ops;

because the $frank.emp would be interpreted as a shell variable, which unless you had previously initialized with a value, would be empty.

To get around this, you must escape the $ sign from the shell with the '\' character like this...

        select * from ops\$frank.amp;

-- 


------------------------------------------------------------------

Steve Schow    | But you don't have to use the claw, if you
sjs_at_netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear


------------------------------------------------------------------