Embedded SQL support for Korn Shell ksh93



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?

.



Relevant Pages

  • Embedded SQL support for Korn Shell ksh93
    ... 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 ...
    (comp.unix.programmer)
  • Re: SQL string problem
    ... clean up your parameters before sending them to SQL. ... > You must "escape" any single quotes when sending SQL statements ... > Just pass your SQL statement through this function when opening your ... >> Here is the full SQL statement that is assigned to the strSQL ...
    (microsoft.public.excel.programming)
  • Re: SQL Statement or Cursor
    ... > Your post seems to ask whether you're better off using a cursor or a sql ... > you can achieve this in a SQL Statement, but I'll offer a caution to you ... SQL Server's tsql doesn't have a rownum ... >> Initial Result Set but lacking Incrementing number. ...
    (microsoft.public.sqlserver.programming)
  • Re: Populating a list -- table structure?
    ... this clears up a lot of issues and jargon with SQL. ... I think I'll have to try to get a query that will take the BKitIDs and the KitIDs and bring that information together. ... Queries (just shows the QBE grid for convenience -- ... and It really helps to use Aliases for tablenames as it makes the SQL statement shorter. ...
    (microsoft.public.access.forms)
  • Re: Emailing a Report
    ... CTRL-G to Goto the debuG window -- look at the SQL statement ... The Sub LoopAgmtsSendEmail is highlighted by the Debugger. ...
    (microsoft.public.access.modulesdaovba)