Shell Programming and Scripting

I am looking for example(s) of how to incorporate SQL into a Bourne Shell for a project that I have been drafted into at work. I am also learning how to write the shell scripts as well as incorporating them together with a TCL routine on the Unix platform to modify a third party application.

Oh, and I am also having to learn my way around the Unix environment as well.... Corporate America... Gotta love it...

Anyhum..

All help and suggestions will be greatly appreciated.

Thanks!

This article provides the techniques most widely used. I personally prefer the co-process method since it provides a continual open channel to the database.

http://tek-tips.com/faqs.cfm?fid=2218

Thomas

I would use modern PHP (or PERL) scripts to communicate with an SQL server, and not legacy shell scripting languages like KSH and SH.

For example, this forum is driven by PHP scripts communicating with a MySQL database. It would be a nightmare to create software as complex as this with /bin/sh ...

Thanks... They focus on Korn, but there shouldn't be much difference. (Hopefully).

I got pulled off to work on some other stuff, now back to this predicament. I agree with Neo, but I don't have a choice. I looked / printed / read over the Korn version, but it doesn't jibe with my current installation (of which I don't have a clue as to which version of what I have to work with now... )

Can anyone give me an Idea if it is even possible to tie Oracle SQL with the Unix Bourne shell...

Thanks.