NOTICE: Our Community is moving. Get more information. Updated information on a New Login Process
As part of a user's system, there are some C or C++ modules that access SQL databases. Can these programs be loaded into Enterprise Analyzer (EA) alongside the Cobol and PL/I code that contains Embedded SQL statements?
EA supports Embedded SQL only in the following languages:
It does not support Embedded SQL in these languages:
So, for C/C++ programs that have Embedded SQL, like Pro*C (i.e. C/C++ programs that work with an Oracle database), then the expanded C/C++ programs must be loaded into EA.
With a Pro*C program, it needs to be processed by the Oracle Pro*C pre-compiler. Normally, the pre-compile, the compile and link would all be done as one task, typically via a make file. As part of that process the C/C++file with the expanded calls may be deleted. Either the make file needs to be altered to retain the expanded C/C++ file or Pro*C needs to be run as standalone process so that the expanded C/C++ file is retained.
To be able to put a Pro*C program into EA and for it to parsed correctly, then the expanded C program that is produced by the Pro*C pre-compiler must be used.
There are various points to note when putting an expanded C program into EA.
Incident # 2692452