Skip to Content

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

Estimated Reading Time: 1 Minutes
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".
How do I get isCOBOL to create a database table when iscobol.file_suffix is set?