|
Home > Archive > Unix Shell > September 2007 > Embedded SQL support for Korn Shell ksh93
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Embedded SQL support for Korn Shell ksh93
|
|
| rgrieco@btmna.com 2007-09-11, 1:18 pm |
| In order to run a SQL statement in Korn shell I have to pass the SQL
statement to the DB2 Command-line processor or in the case of Oracle
to SQL*Plus as a here-document.
Although this works it is a bit sloppy. I have not been able to find
a Korn shell solution, which would allow true embedded SQL support,
such as PERL DBI or Rexx with DB2 support.
Does anyone know of a solution (software package, function or open
source code), which would enable Korn shell to support embedded SQL?
| |
| Roland Mainz 2007-09-26, 1:34 am |
| rgrieco@btmna.com wrote:
> In order to run a SQL statement in Korn shell I have to pass the SQL
> statement to the DB2 Command-line processor or in the case of Oracle
> to SQL*Plus as a here-document.
> Although this works it is a bit sloppy. I have not been able to find
> a Korn shell solution, which would allow true embedded SQL support,
> such as PERL DBI or Rexx with DB2 support.
ksh93 supports binary plugins which could be used to add something like
that, e.g. Oracle SQL bindings for ksh93 (a more complex example can be
found in
http://src.opensolaris.org/source/x...iocmd_solaris.c
, function |b_poll()| which implements a "poll" builtin which works like
the poll(2) function).
----
Bye,
Roland
--
__ . . __
(o.\ \/ /.o) roland.mainz@nrubsig.org
\__\/\/__/ MPEG specialist, C&&JAVA&&Sun&&Unix programmer
/O /==\ O\ TEL +49 641 7950090
(;O/ \/ \O;)
|
|
|
|
|