support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
 

Veryant Knowledge Base
Home > All Categories > Data Access > COBOL/ESQL and Veryant ESQL Generator > How do I migrate a Vision file to an Oracle database table?
Question Title How do I migrate a Vision file to an Oracle database table?

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:

  1. 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.
  2. 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.
  3. 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.
Authored by: Veryant Support This question has been viewed 7027 times so far.
Click Here to View all the questions in COBOL/ESQL and Veryant ESQL Generator category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
  1. How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
  2. How do I use isCOBOL ESQL with Microsoft SQL Server?
  3. When to set iscobol.jdbc.autocommit=false when using ESQL
  4. How do I connect to a MS SQL 2005 Named Instance?
  5. Where is the Veryant ESQL generator? What files do I download?
  6. How does isCOBOL limit the size of database query working set for the START statement?
  7. How do I get isCOBOL to create a database table when iscobol.file_suffix is set?
  8. How is READ NEXT implemented in isCOBOL ESQL Generator (EasyDB)?
  9. How is it possible to insert a NULL into an ORACLE TABLE when host variable has been initialized?
Article Information Additional Information
Article Number: 25
Created: 2009-08-28 2:26 PM
Rating: No Rating
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base



 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.