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 > Does isCOBOL support PostgreSQL?
Question Title Does isCOBOL support PostgreSQL?

isCOBOL supports Postgres (PostgreSQL) in two ways:

  1. Through a built-in COBOL/ESQL compiler which translates EXEC SQL statements to JDBC
  2. Through isCOBOL ESQL Generator which creates bridge programs that route COBOL indexed file I/O statements to Postgres through JDBC

For sample programs see PostgreSQL Example with COBOL/ESQL and ISAM-to-RDBMS bridge (isCOBOL ESQL Generator) in the Veryant Discussion Forums under Sample Programs.

PostgreSQL 9.0.1 can be downloaded from http://www.enterprisedb.com/products/download.do

The PostgreSQL JDBC driver can be downloaded from http://jdbc.postgresql.org/download.html

For example, create a folder C:\Program Files\PostgreSQL\9.0\jdbc4 and place postgresql-9.0-801.jdbc4.jar in that folder.

To create a test database, run pgAdmin III from "Start Menu" >> "PostgreSQL 9.0". Right-click on the server "PostgreSQL 9.0" and Connect. Right-click on Databases and select "New Database...". Name the database "test" and take all of the defaults.

The isCOBOL properties to use are as follows:

iscobol.jdbc.driver=org.postgresql.Driver
iscobol.jdbc.url=jdbc:postgresql://localhost/postgres?user=myusername&password=mypassword

replacing myusername and mypassword with the correct values.

Remember to include the PostgreSQL JDBC jar file in your class path. For example,

set CLASSPATH=C:\Program Files\PostgreSQL\9.0\jdbc4\postgresql-9.0-801.jdbc4.jar;%CLASSPATH%

See also Where can I get products and services for Postgres (PostgreSQL)?

Authored by: Veryant Support This question has been viewed 5516 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. How do I connect to a MS SQL 2005 Named Instance?
  4. How do I migrate a Vision file to an Oracle database table?
  5. Set iscobol.jdbc.autocommit=false when using ESQL in TP environments
  6. Where is the Veryant ESQL Generator? What files do I download?
  7. How does isCOBOL limit the size of database query working set for the START statement?
  8. How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?
  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: 111
Created: 2009-11-12 1:20 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.