Re: Programming languages that make DBA's lives easier

I know little about WSH, but it fairly sure it's not a language.

It's a 'scripting host', an engine that allows you to plug in a scripting language. I believe it even runs Perl. :)

Jared

On Tuesday 18 February 2003 18:43, Maria Aurora VT de la Vega wrote:
> PLSQL, java and shell scripting. Can't say perl...have yet to start
> learning it.
>
> I don't know if you guys are having problems with your batch programs in
> Windows...
> but a few of the old DOS commands I used to use don't work on Win2k
> anymore... like choice. And whenever I search for more information
> regarding Windows scripting...
> I stumble on WSH.
> Any thoughts on this scripting language? Is this worth a DBAs time?
>
> =)
>
> Janardhana Babu Donga wrote:
> > What are the good books you guys recommend for Shell Programming? I have
> > old edition of UNIX shells by example (by Ellie Quigley). I need to
> > replace this with some good book.
> >
> > Do I need to learn perl before reading PERL for DBAs? If so, what are the
> > good perl books do you guys recommend?
> >
> > -- Babu
> >
> > -----Original Message-----
> > Sent: Tuesday, February 18, 2003 1:04 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > I thought it might be worthwhile to say WHY I prefer ksh for most
> > scripting.
> >
> > As one writer put it, use a language you know. I've used ksh for years,
> > so that is certainly one big factor in preferring it. But, that aside,
> > if you use mostly the Bourne Shell syntax and stay away from the some of
> > the Korn Shell syntactical candy that doesn't do anything extra, then
> > your scripts are very easy to read, and are mostly self-documenting. For
> > me, that is a big advantage.
> >
> > If you use ksh, then you need to become reasonably proficient with a few
> > of the more important utilities such as sed and awk/nawk/gawk and become
> > familiar with good old regular expressions (wonderful stuff!).
> >
> > One area where ksh is weak is its inability to set up a two-way socket
> > with a child process like sqlplus. Perl can do this (for example, by
> > using IPC::Open2). With ksh, you can send to the child, and you can
> > receive from the child, but you can't converse with the child. Even with
> > the coprocess (which is a pain to use), you still have one-way
> > communication at any given time. However, 99% of the time, ksh will work
> > fine. For that other 1% (OK, maybe 2%), you either figure out a workable
> > compromise with ksh, or you use perl.
> >
> > If you want some reading material, my recommendation is:
> >
> > Unix System V: A Practical Guide
> > by Mark G. Sobel
> >
> > (There is also a version for BSD)
> >
> > This is a outstanding overview of Unix including sh, ksh, and csh
> > programming; as well as good introductions to sed, awk, and regular
> > expressions. It also has chapters on emacs and vi ("Remember, vi is your
> > friend."). Amazon has the 3rd edition listed with a publish date of
> > 1995. So there probably is some rather outdated info in the book on stuff
> > like gopher, archie, possibly Mosaic (Oh heeeeey, cool!). Just ignore
> > this. All the other stuff is still completely relevant and presented in
> > what I think is the perfect level of detail -- not too verbose; not too
> > terse -- with good examples.
> >
> > Eventually, to get seriously cooking with sed and awk, you will need to
> > get something like the O'Reilly sed and awk book. But, for ksh
> > programming: If you work through the Bourne Shell and Korn Shell chapters
> > of the Sobel book, it is likely that this book is all you will ever need.
> > Another wonderful thing about this book is that it doesn't use the
> > current trend of big fonts with big margins and thick paper to create a
> > monster sized book. Instead, you get lots of information in a book that
> > takes up little shelf space. --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Stephen Lee
> > INET: Stephen.Lee_at_DTAG.Com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Janardhana Babu Donga
> > INET: jbdonga_at_ucdavis.edu
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Maria Aurora VT de la Vega
> Oracle DBA
> Philippine Stock Exchange, Inc.
>
> "Failure is only postponed success as long as courage 'coaches' ambition.
> The habit of persistence is the habit of victory."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).