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".
|
Authored
by: Veryant Support
This question has been viewed 6563 times so far.
|
Click
Here to View all the questions in COBOL/ESQL and Veryant ESQL Generator
category. |
File Attachments |
There are no attachment file(s) related to this question. |
|
User Comments |
|
|
There are no user comments for this question. Be the first to post a comment. Click Here |
Related Questions
|
- How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
- How do I use isCOBOL ESQL with Microsoft SQL Server?
- How do I migrate a Vision file to an Oracle database table?
- When to set iscobol.jdbc.autocommit=false when using ESQL
- How do I connect to a MS SQL 2005 Named Instance?
- Where is the Veryant ESQL generator? What files do I download?
- How does isCOBOL limit the size of database query working set for the START statement?
- How is READ NEXT implemented in isCOBOL ESQL Generator (EasyDB)?
- How is it possible to insert a NULL into an ORACLE TABLE when host variable has been initialized?
|