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