How do I get isCOBOL to create a database table when iscobol.file_suffix is set?


Question:

My application requires iscobol.file_suffix to be set to DAT. I have moved some files to database tables using isCOBOL ESQL Generator (EasyDB).

Answer:

You need to include the file suffix in the file name when specifying iscobol.file.index.FileName. For example, if you have a file named AC100 and iscobol.file_suffix=DAT, then the final file will be named AC100.DAT. So you need to set iscobol.file.index.AC100.DAT=easydb. 

For example:

iscobol.file.index=ctree
iscobol.file_suffix=DAT 

iscobol.file.index.AC100.DAT=easydb iscobol.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver iscobol.jdbc.url=jdbc:sqlserver://localhost 


You can set the iscobol.file.index.FileName programatically with SET ENVIRONMENT. For example: 

SET ENVIRONMENT "file.index.AC100.DAT" TO "easydb".


Article ID: 20
Created: August 28, 2009
Last Updated: May 19, 2022
Author: Support KB Author

Online URL: https://support.veryant.com/phpkb/article.php?id=20