Re: SHell programming on NT

Hello:

I believe you will get the desired results if you create a SQL script and pass the name as a parm, like so:
sqlplus $1/$2_at_instance @scriptname.

For scripting on NT, the obvious choice is DOS command files, which really doesn't give you very much. We are using the Windows Scripting Host (downloadable for free from Microsoft). It allows you to use VBscript as a host scripting language, which is not quite to the level of unix shell scripting, but it's a heckuva lot better than just plain DOS bat or cmd files.

Good luck,
Dave

sunita_at_postoffice.worldnet.att.net wrote in message <35D57BE2.7987_at_postoffice.worldnet.att.net>...
>To all NT database administrator:
>
>1. WHich shell programming tool do you use?
>2. WHich one have you found simple, easy and best?
>
>I am trying to use ksh shell which comes as a part of MKS toolkit.
>I call the script this way:
>c:\mks\mksnt count_objects.ksh username password instance
>
>where count_objects.ksh has the following:
>
>sqlplus $1/$2_at_instance << !EOF!
>
>set heading off
>spool drop_objects_$3.log
>
>blah...
>
>spool off
>exit
>EOF
>
>I am having thsi problem: sqlplus opens and does nothing
>but wait there..what is happening??
Received on Sat Aug 15 1998 - 13:20:27 CDT