Where can I get products and services for Postgres (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 the samples installed with your SDK. An example of #1 above is here: $ISCOBOL%sampledata-accessesql and an example of #2 is here: %ISCOBOL%sampleeasydbpostgres
For each of these methods you'll need the JDBC url and driver. The syntax for the jdbc url is: 
   jdbc:postgresql://:<Port>/<DatabaseName>?user=<UserName>&password=<Password>
For example: 
   iscobol.jdbc.driver=org.postgresql.Driver
   iscobol.jdbc.url=jdbc:postgresql://localhost/postgres?user=postgres&password=manager
PostgreSQL can be downloaded from here: https://www.postgresql.org/download/ or here: https://www.enterprisedb.com/software-downloads-postgres

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

The Postgres JDBC jar file must be in the CLASSPATH. The easiest way to do this is to put it into the %ISCOBOL%jar folder, which the runtime checks automatically

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.
You can find Postgres products and services here: https://www.postgresql.org/


Article ID: 155
Created: November 9, 2010
Last Updated: May 17, 2022
Author: Support KB Author

Online URL: https://support.veryant.com/phpkb/article.php?id=155