Saturday, February 25, 2012

osql :r filenames with spaces

osql :r doesn't seem to like file names with spaces. Don't want to have to
use shortnames if I don't have to.
What's the fix?
Thanks
Martin
Hi,
Use double quotes (") while mentioning the file names with spaces (special
charecters)
Sample:-
osql -Usa -Sa266uss\harisql -Phari -Q"select * from
master..sysobjects" -o"c:\sys objects.txt"
Thanks
Hari
MCDBA
"Martin" <x@.y.z> wrote in message
news:e67N1YkaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> osql :r doesn't seem to like file names with spaces. Don't want to have
to
> use shortnames if I don't have to.
> What's the fix?
> Thanks
> Martin
>

No comments:

Post a Comment