Re: cobol embedded sql source example

On Wed, 3 May 2006 08:02:11 -0400 "Serge Lacombe" <serge.lacombe@xxxxxxxxxxxx>
wrote:

:>I need to obtain the list of elements (name of column,type..) of an Oracle
:>table.

In DB2 one would do a prepare of a "SELECT *" to get this information.

I presume Oracle has a similar type of function.

Of course, if the program has authority to read the catalog tables, it may be
easier.

:>Can it be done in a cobol embedded sql program?

I don't think COBOL is able to handle the DB2 one.

:>If yes, a source dode example would be appreciated.

I am sure that it would be.

--
Binyamin Dissen <bdissen@xxxxxxxxxxxxxxxxxx>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me,
you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.
.

Relevant Pages

  • Re: Static or Dynamic Call.
    ... :>with the values from flat file. ... Do you really think that you can bluff DB2 knowledge with a few quick answers? ... I very rarely bother responding to challenge/response systems, ...
    (comp.lang.cobol)
  • Re: Inserting data into DB2 tables using REXX
    ... You would probably be better off using the program to massage it into LOAD ... format and use the standard DB2 load utility. ... I very rarely bother responding to challenge/response systems, ...
    (comp.lang.rexx)