Re: cobol embedded sql source example
- From: "Günther De Vogelaere" <Gunther.DeVogelaere@NOSP@M.Ugent.be>
- Date: Wed, 3 May 2006 14:59:06 +0200
"Serge Lacombe" <serge.lacombe@xxxxxxxxxxxx> schreef in bericht
news:cKmdnSCeW8FeBsXZnZ2dnUVZ_smdnZ2d@xxxxxxxxxxxxxxx
Hi,
I need to obtain the list of elements (name of column,type..) of an Oracle
table.
Can it be done in a cobol embedded sql program?
If yes, a source dode example would be appreciated.
Thanks.
The sql statement you could use:
select * from all_tab_columns
where table_name = 'insertherethetableyouwanttosee'
(replace the * by the columnames of the table all_tab_columns you want to
see)
Declare your hostvariables:
<http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96109/pco05sql.htm>
Opening a cursor, loop through cursor, and close it, should be trivial:
<http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96109/pco05sql.htm#817>
You surely can find examples of cursors that use other tables.
.
- References:
- cobol embedded sql source example
- From: Serge Lacombe
- cobol embedded sql source example
- Prev by Date: Re: cobol embedded sql source example
- Next by Date: Re: Calling a COBOL-DB2 program from a pure COBOL program.
- Previous by thread: Re: cobol embedded sql source example
- Next by thread: Re: cobol embedded sql source example
- Index(es):
Relevant Pages
|
