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 set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
Question Title How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
Question:

How do use isCOBOL ESQL Generator and the isCOBOL ESQL Runtime with Microsoft SQL Server? Can you give me an example?

Answer:

Here is an example,

  1. Set CLASSPATH=.;C:Program FilesVeryantisCOBOL2015R1libiscobol.jar;C:Program FilesVeryantisCOBOL2015R1libutility.jar;C:Program FilesVeryantisCOBOL2015R1libedbi.jar;C:Program FilesJavajdk1.8.0lib ools.jar;C:Program FilesJavajdk1.8.0jrelib t.jar;C:Program FilesMicrosoft SQL Server 2005JDBC Driversqljdbc_1.2enusqljdbc.jar

    Notice that CLASSPATH contains all of the following:
    .
    C:Program FilesVeryantisCOBOL2015R1libiscobol.jar
    C:Program FilesVeryantisCOBOL2015R1libutility.jar
    C:Program FilesVeryantisCOBOL2015R1libedbi.jar
    C:Program FilesJavajdk1.6.0lib	ools.jar
    C:Program FilesJavajdk1.6.0jrelib
    t.jar
    C:Program FilesMicrosoft SQL Server 2005JDBCDriversqljdbc_1.2enusqljdbc.jar
  2. Make sure that PATH contains C:Program FilesVeryantisCOBOL2015R1in and the JDK bin directory

  3. Use the following iscobol.properties if you want to use ISMIGRATE to migrate a Vision version 3 file to SQL Server.

    iscobol.vision.f_version=3
    iscobol.ismigrate_logging=1
    iscobol.ismigrate_input_file_index=vision
    iscobol.ismigrate_output_file_index=easydb
    iscobol.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    iscobol.jdbc.url=jdbc:sqlserver://192.168.1.10:1433;databaseName=mydbname

    (I used iscobol.jdbc.url=jdbc:sqlserver://localhost;databaseName=mydbname)

    Replace 192.168.1.10 with the correct IP address and mydbname with the correct name for your database.

    If you are migrating from JISAM then add the following property:

    iscobol.ismigrate_remove_extension=dat

  4. Compile your COBOL program that has the SELECT for the file with -efd
  5. Run the edbiis utility to create the bridge program
    edbiis "-ld=C:program filesveryantiscobol2015R1easydb	emplate" -ds filename.xml
    
    (where filename is the name of your data file)
  6. Compile EDBI-filename.srv (where filename is the name of your data file)
  7. java ISMIGRATE FILENAME (where FILENAME is the name of your file)

    Example output:
    (i) Migrating filename [filename] (i) migration OK (i) 1 read, 1 written, 0 skipped 1 Migrations completed 0 Migrations failed
  8. To change the configuration for your actual application, comment or remove the following lines:
    #iscobol.vision.f_version=3
    #iscobol.ismigrate_logging=1
    #iscobol.ismigrate_input_file_index=vision
    #iscobol.ismigrate_output_file_index=easydb
    
    and add one of the following:

    iscobol.file.index=easydb 
    or
    iscobol.file.index.FileName=easydb 

    The FileName part of iscobol.file.index.FileName is the same as the name of the physical file except that it should be all lowercase.
Authored by: Veryant Support This question has been viewed 4605 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. Does isCOBOL support PostgreSQL?
  2. How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
  3. How do I use isCOBOL ESQL with Microsoft SQL Server?
  4. How do I connect to a MS SQL 2005 Named Instance?
  5. How do I migrate a Vision file to an Oracle database table?
  6. Set iscobol.jdbc.autocommit=false when using ESQL in TP environments
  7. Where is the Veryant ESQL Generator? What files do I download?
  8. How does isCOBOL limit the size of database query working set for the START statement?
  9. How is READ NEXT implemented in isCOBOL ESQL Generator (EasyDB)?
  10. How do I get isCOBOL to create a database table when iscobol.file_suffix is set?
  11. How is it possible to insert a NULL into an ORACLE TABLE when host variable has been initialized?
Article Information Additional Information
Article Number: 33
Created: 2009-08-28 4:42 PM
Rating: 1 Star
 
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.