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
    4
  • Subscribers subscribers
    15
  • Views views
    216
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Visual COBOL 8 managed .net DEF_CURSOR is not valid for this product

James Ettridge

Hi

I'm running into an error when using a cursor that fetches 0 results which results in an error and reports 'SQL error -9514 Invalid Cursor State)'.  We are using the current SQL directives:

SQL(DBMAN=ADO) SQL(BEHAVIOR=ANSI) SQL(CHECK) SQL(DB=CSISD) SQL(TARGETDB=MSSQLSERVER) SQL(DEF_CURSOR=RO) SQL(ALLOWNULLCHAR)

Running from a Windows 10 VM to SQL Server 2016 on a Windows Server 2012 rd (soon to be Windows Server 2022).

I've found that DEF_CURSOR is still valid as per the Micro Focus documentation however according to VS 2019 'Invalid directive. The selected directive is not valid for this version of the product'.

Any ideas?

James

  • 0  

    Hi James,

    What Visual COBOL 8.0 Patch Update level do you have installed?

    I tested this with 8.0 PU6 and I am not experiencing your reported behavior. I do not get a compile error on the directive and when the fetch is done it returns -100 as it should. 

    I did my test with SQL Server 2017.

    Chris Glazier
    Global Technical Support | OpenText

    If you found this post useful, give it a “Like” or click on "    Verify Answer" under the "More" button

  • 0 in reply to Chris Glazier

    Hi Chris

    A decision was made by the team to run v8 with no patch updates however I had suggested we do so.  I've spoken with the team now and I will proceed to update to PU6 and will let you know if this resolves the issue.

  • 0   in reply to James Ettridge

    I also tested this here without any patch updates and I still did not experience the problem, but I am using a very simply program. It will be interesting to see if updating does indeed fix the problem on your end.

    Does this happen on any program that has SQL in it or is it isolated to specifc programs?

    Chris Glazier
    Global Technical Support | OpenText

    If you found this post useful, give it a “Like” or click on "    Verify Answer" under the "More" button

  • 0 in reply to Chris Glazier

    Thanks Chris

    On a further debug session I've noted that when a record is fetched successfully then the subsequent fetch nets a null result we receive -9514 which from what I can see indicates the cursor is still open. I've been able to implement a change to one of our SQL copybooks to counteract this.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
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.