Problem:
When the statement "EXEC SQL INCLUDE aFile END-EXEC" is used, ORACLE precompiler PROCOB looks for a file named 'Afile.cob' on the current directory AND, if not found on the current directory, looks for it on DIRECTORIES pointed by the environment variable INCLUDE.
How to manage ORACLE precompiler PROCOB to find these files despite they don't have the cob extension?
Resolution:
Use the Micro Focus CP Preprocessor so COPYFILEs are "expanded" before ORACLE precompiler has to deal with them ( ie: since CP will have expand COPYFILEs, procob won't have to look for them....)
Sample Paste of Net Express directives of a Net Express project:
%FILENAME COBIDY(%TARGETDIR) WB3 WB CSI ANIM EDITOR(MF2) ENSUITE(3) PREPLIST LIST() osext"pco" copyext"cob,pco,cbl,cpy" p(cobsql) csqlt=ora8 makesyn end-c
comp-5=yes p(CP) C S T W ENDP;
Note that, since the Preprocessor CP is used to expand COPYFILEs prior to ORACLE precompiler,
the Environment variable, used to find COPYFILEs not being on the current directory, is COBCPY and not INCLUDE ( which was used by the EXEC SQL INCLUDE aFile END-EXEC statement )
Extract of Net Express on-line help on the keyword CP Preprocessor:
CP Directives
The CP preprocessor accepts a number of directives. In order to keep the command line short, these exist in an abbreviated form in addition to the full name. After looking at the command line in the usual way, CP also looks at the environment variable CPDIR for directives.
The following directives are available for the CP preprocessor:
...
