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: FW: CEE0813S Insufficient Storage
    ... :>4)It reads some tables DB2 and add data to a single table. ... I very rarely bother responding to challenge/response systems, ... For IBM-MAIN subscribe / signoff / archive access instructions, ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ...
    (bit.listserv.ibm-main)
  • 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)
  • Re: STC is canceled and forced, but still wont go away
    ... Before you force any address space that has threads in DB2 you should kill the threads otherwise you get this situation. ... With a DB2 monitor you should be able to identify and kill the thread. ... I very rarely bother responding to challenge/response systems, ...
    (bit.listserv.ibm-main)