[cobol] * CSQL-I-003: COBSQLTYPE is incorrect defaulting to Oracle

When using INCLUDE copyfiles that are not in the current directory with Oracle's Procobol preprocessor you might need to add the Micro Focus Copy Preprocessor (CP) to the command so that the copybooks can be found.

Please see the knowledgebase article here:

i have configured below in SQL preprocessor

P(cobsql) COBSQLTYPE=ORACLE8 DISPLAY MAKESYN VERBOSE=true END-COBSQL comp5=yes hold_cursor=yes mode=ansi varchar=yes sqlcheck=full userid=XXXXX/XXXXX@dbname ENDP

Please don't include actual userids and passwords in your examples:

Try adding the p(cp) commpand before the END-P:

P(cobsql) COBSQLTYPE=ORACLE8 DISPLAY MAKESYN VERBOSE=true END-COBSQL comp5=yes hold_cursor=yes mode=ansi varchar=yes sqlcheck=full userid=xx/xxx@dbname p(cp) ENDP

Hi chris ,

Again Im facing same issue , 

gswcobol_build_config.FileCompile:

FileCompile.gswcobol_build_config.cobol:
[cobol]
[cobol] Compiling GIFPWC60.PCO...
[cobol]
[cobol] * Cobsql Integrated Preprocessor
[cobol] * CSQL-I-049: Unable to support the SOURCETABSTOP directive, defaulting to 8
[cobol] * CSQL-I-003: COBSQLTYPE is incorrect defaulting to Oracle
[cobol] * CSQL-I-018: Invoking Oracle Precompiler/Translator
[cobol]
[cobol] System default option values taken from: C:\\app\\va27\\product\\11.2.0\\client_1\\precomp\\admin\\pcbcfg.cfg

P(cobsql) COBSQLTYPE=ORACLE8 DISPLAY MAKESYN VERBOSE=true END-COBSQL comp5=yes hold_cursor=yes mode=ansi varchar=yes sqlcheck=full userid=xx/xxx@dbname p(cp) ENDP

Do i need to re-install oracle with precompile customized option ? please help me 

What is the error that you are getting now? Are you still getting the include file error after adding the p(cp) option? What is the extension on your include file? You may have to add in in the COPYEXT directive if it is a non-standard one.

Please see the docs here.

The other messages you are receiving are informational only and are not errors. COBSQLTYPE=ORACLE and COBSQLTYPE=ORACLE8 are exactly the same as Oracle no longer supports versions prior to V8.

Hi Chris.

Please find compile directives file :

copyext(pco,cpy,cob,cbl) osext(pco,cbl) P(COBSQL) COBSQLTYPE=ORACLE8 DISPLAY MAKESYN SQLBGP VERBOSE END-C comp5=yes hold_cursor=yes mode=ansi varchar=yes sqlcheck=full userid=xxx/xxx@dbname p(cp) ENDP ibmcomp noalter notrunc NOFASTINIT list() change-message(CH1123 n CH1125 n CH1126 n CH1129 n CH1140 n CH0399 n CH0750 n)

Additional Preprocessor:

P(cobsql) COBSQLTYPE=ORACLE8 DISPLAY MAKESYN VERBOSE=true END-COBSQL comp5=yes hold_cursor=yes mode=ansi varchar=yes sqlcheck=full userid=xxx/xxx@dbname p(cp) ENDP

After Compile  im getting:

Cobsql Integrated Preprocessor
[cobol] * CSQL-I-049: Unable to support the SOURCETABSTOP directive, defaulting to 8
[cobol] * CSQL-I-003: COBSQLTYPE is incorrect defaulting to Oracle
[cobol] * CSQL-I-018: Invoking Oracle Precompiler/Translator
[cobol]
[cobol] 98
[cobol] System default option values taken from: C:\\app\\va27\\product\\11.2.0\\client_1\\precomp\\admin\\pcbcfg.cfg
[cobol] COBCH0803S 000106:Unable to open INCLUDE file "COPYCOM1" : C:\\VisualCobolWorkspace\\source_project\\GIFPCD51.pco(98,9,9)
[cobol]

Same Issue still exist.

Where is COPYCOM1 located on disk and what is its full name?

If it is in a different folder then you will need to either add its folder name to the COBCPY environment variable or add the COPYPATH directive to your list of directives and specify the full path name to the folder.

COPYPATH docs

Hi chris,

COPYCOM1 located in 

C:\\VisualCobolWorkspace\\include_project

same i have mentioned in environment variable

Try adding the INCLUDE option to your Oracle Procob options in pcbcfg.cfg or on the command line:

INCLUDE=C:\\VisualCobolWorkspace\\include_project

Hi Paul,

I have been doing some research on my end and I can reproduce the behavior you are experiencing. What appears to be happening is that when turning on certain combinations of directives in the Eclipse IDE, including the SQL preprocessor directive,  the directives file becomes corrupt so that the P(CP) directive is not being picked up. This means that the copybook preprocessor that searches for copybooks using COBCPY locations and extensions using COPYEXT is not being run and so the files are not being found. I can see in your screenshot that the messages do not include output from the copybook preprocessor.

Adding the INCLUDE option to the ProCOBOL file should allow the files to be found but I am continuing to look for the exact cause of the problem and hopefully a workaround.

If you would like to create a support incident nfor this and put ATTN: Chris Glazier in the subject then I can create a bug report for the problem.

Thanks

Some more information. 

Please check the following:

Right click on the project name and select Properties.

Are you setting your SQL Preprocessor and Additional Preprocessors options under the COBOL tab of the Build Configurations option or the Project Settings?

If they are set under Build Configuration I find that the problem with CP not running occurs. If they are set only under Project Settings then all works properly. 

If the option for Enable configuration specific settings is checked in any of the options under Build Configurations->COBOL then uncheck them and click Apply on each page.