Problem:
Using Oracle with following directives:
p(cobsql) COBSQLTYPE=ORACLE8 CSTART VERBOSE DISPLAY KEEPCBL END-C SQLCHECK= FULL USER= USERID/PASSWORD@CONNECTSTRING ENDP;
* CSQL-I-018: Invoking ORACLE8 Precompiler/Translator
* CSQL-E-036: Unable to open the precompiler file: "sample1.cs9"
* CSQL-E-023: File Status 3/ 5
Resolution:
When using sqlcheck=full and user=userid/password@connectstring along with many cobsql directives it map be possible to receive the above error if the string being passed to cobsql is very long.
Place the Oracle directives sqlcheck & user in the Oracle config file (pcbcfg.cfg) to shorten the list passed to cobsql.