Title: 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://:/?user=&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/

Authored by: Veryant Support on Tue, Nov 9th, 2010 at 7:00 PM
This question has been viewed 8720 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=155

Powered by PHPKB Knowledge Base Software