How do I migrate a Vision file to an Oracle database table?

Question ID : 25
Created on 2009-08-28 at 2:26 PM
Author : Veryant Support [support@veryant.com]

Online URL : http://support.veryant.com/support/phpkb/question.php?ID=25

Question:
I know that one way to migrate a Vision indexed file to an Oracle database table is by writing a program that reads records from one logical file and writes them to another using the same FD and the following properties:

   iscobol.file.index.physical_filename_1=com.iscobol.io.ScanVision
   iscobol.file.index.physical_filename_2=easydb
   iscobol.jdbc.driver=oracle.jdbc.OracleDriver
   iscobol.jdbc.url=jdbc:oracle:thin:@machine_name:port

Is it possible to do this using ISMIGRATE? If so, then how do I set it up?

Answer:
Yes. Here are the steps:

Compile the program using these compile properties:
```
   iscobol.compiler.easydb=1
   iscobol.compiler.easydb.oracle=1
```
This will create a bridge COBOL program called ORAEDBI_FILENAME.class.
With the bridge program in the current folder or CLASSPATH, run ISMIGRATE with this configuration, either on the command line or in a properties file:
```
   iscobol.easydb.prefix=ora
```
You can also include the driver and URL information here, or wait and put it into the ISMIGRATE Wizard fields when asked.
In the ISMIGRATE wizard, choose Acucobol Vision in the "From" field, and isCOBOL DatabaseBridge (easydb) in the "To" field. Follow the prompts in the wizard.

Back to Original Question