Embedded SQL in COBOL (was: If you were inventing CoBOL...)

From: Lko Willms (lw-nospam_at_t-online.de)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 10:35:15 +0200 (MES)

On Tue, 21 Sep 2004 21:52:11 GMT, Robert Wagner wrote:

>
>It's not clear what you mean by arbitrary. If the SQL is talking
>through an ODBC driver, it can access any brand of relational
>database, indexed file, sequential file or spreadsheet.
>
>It's not possible to separate the pre-processor from the runtime
>because there's no standard for runtimes.

   When the compiler provides an ODBC client driver, i.e. a facility to send
SQL commands to an ODBC server, the compiler could do it by itself without an
preprocessor, isn't it? I would prefer that.

   I had worked with ESQL in COBOL using the UCOB, i.e. COBOL-85, compiler
for Unisys OS/1100 (Clearpath IX), and that did not require a preprocessor.
The compiler called the RDMS runtime system to check the validity of the
commands and table references.

   Since an ODBC client is initially detached from the database server, the
compiler could work the same way, don't you think so?

Yours,
L. Willms
------------------------------ all rights reserved ------------------------

Relevant Pages

  • Re: [PHP] ODBC and long text fields
    ... "Text" is a MS SQL field for ... MSSQL specific php extension? ... MSSQL functions still require an ODBC driver underneath, ...
    (php.general)
  • Re: Embedded SQL in COBOL (was: If you were inventing CoBOL...)
    ... If the SQL is talking ... >>database, indexed file, sequential file or spreadsheet. ... > When the compiler provides an ODBC client driver, ...
    (comp.lang.cobol)
  • Re: Incorrect number of parameters, expected 2.
    ... ODBC will replace them with whatever the underlying driver wants. ... Since Matt was able to get it to work with the table name in double quotes ... I believe him when he says it's a bug in the ODBC driver. ... > MNM> string constants embedded in the SQL. ...
    (microsoft.public.data.odbc)
  • Re: AS400 & filter by date
    ... we need to import data from AS400 to MS SQL 2000 via ODBC driver ... (iSeries ODBC by IBM). ... with system date (MS SQL) ... CURRENT_DATE which you would then have to convert to the number format that ...
    (microsoft.public.sqlserver.dts)
  • Re: HOWTO?: force optimizer to use a "remote index join" when joining local to remote table
    ... If you are using ODBC, you can turn on ODBC tracing ... This will work for any ODBC driver or client, ... ODBC messages take the form of SQL statements. ... syntax is similar to MS SQL Server SQL. ...
    (microsoft.public.access.externaldata)