Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies replies
    2
  • Subscribers subscribers
    16
  • Views views
    122
  • Users 0 members are here
Related
Options

How to use ODBC with postgres database on linux

Laurent Vasseur

Hello,

I want to use ODBC connection to postgres database  with a cobol SQL program (Visual Cobol + oesql).

I've got this error :

SQL CODE : 000019520-
ORDER : OPEN CURPARMOD
MESSAGE SQL : Connection does not support HOLD cursors

How can i configure my ODBC.ini to work correctly with HOLD cursor

Or is there a postgres ODBC driver on Linux with HOLD cursor capability ?

Thanks for your help.

Laurent.

  • 0  

    Hi Laurent,

    The Visual COBOL documentation for DECLARE CURSOR states the following:

    • If a HOLD cursor is requested and the current connection closes cursors at the end of transactions, the OPEN statement will return an error (SQLCODE = -19520).

    By default, the cursor behavior is set to close cursors after a COMMIT. You can change this behavior by adding the following SQL directive to your program:

    SQL(CLOSE_ON_COMMIT=NO)

    This is documented here.

    Chris Glazier
    Rocket Software - Principal Technical Support Specialist
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

  • 0 in reply to   

    It's OK.

    Thank you for your help.

    Regards.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.