Re: cobol embedded sql source example
- From: Frederico Fonseca <real-email-in-msg-spam@xxxxxxxxx>
- Date: Wed, 03 May 2006 19:10:18 +0100
On Wed, 3 May 2006 08:02:11 -0400, "Serge Lacombe"
<serge.lacombe@xxxxxxxxxxxx> wrote:
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.
Answer is yes. (WITH ORACLE)
see
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12019.htm
for a full description. You may need to create a user to view the
document above.
Bat basics are
Syntax
DESC[RIBE] {[schema.]object[@db_link]}
Lists the column definitions for the specified table, view or synonym,
or the specifications for the specified function or procedure.
Terms
schema
Represents the schema where the object resides. If you omit schema,
SQL*Plus assumes you own object.
object
Represents the table, view, type, procedure, function, package or
synonym you wish to describe.
@db_link
Consists of the database link name corresponding to the database where
object exists.
The above method needs to be done with a dynamic SQL, and if you only
need the table information then you can hardcode the columns required.
Note. Never tried it with ESQL.
For another method that is sure to work see.
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/a96109/pco11ody.htm#sthref1655
You will need to create a new user if you are not already registered.
DO IT if you are going to be dealing with Oracle, as it is required
for all type of access to their website.
Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com
.
- References:
- cobol embedded sql source example
- From: Serge Lacombe
- cobol embedded sql source example
- Prev by Date: OpenCobol 0.33 binaries
- Next by Date: Reverse Engineering a COBOL program
- Previous by thread: Re: cobol embedded sql source example
- Next by thread: Re: cobol embedded sql source example
- Index(es):
Relevant Pages
|
