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 > What is 9l,10 error and why is it happening?
Question Title What is 9l,10 error and why is it happening?

The problem is in these lines of your select statement:

100008     RECORD KEY IS FILE1-KEY
100009     ALTERNATE RECORD KEY IS FILE1-KEY,

You have defined the alternate key to be the same as the primary key, and you're using a file handler that doesn't support this (ex: JIsam).
If you comment out the ALTERNATE line then you will no longer get the error.
If you need to use identical keys, you can use the c-treeRTG file handler, which allows this syntax.

To diagnose the problem, run your program with the following properties:

iscobol.logfile=log.txt
iscobol.tracelevel=63

In the resulting "log.txt" file you will find the file status along with the extended file status.
The line for this error was:

Oct 28, 2020 21.41.49.669 INFO: Unknown error FILE1 (FILE1.DAT) FS=[9l],EXFS=[108]: unknown error

This shows that the error reported in your error message, 91,10 is actually a 91,108. The 108 error is further identified in our KB for how to diagnose 9? Errors: How do I interpret file status 9? and other EXFS extended file status codes (e.g. 9i,105)? This article shows the following:

/* 108 */ "key already exists"

Indicating that the OPEN was trying to add a key that was already added.

Authored by: Veryant Support This question has been viewed 8237 times so far.
Click Here to View all the questions in Data Access 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. File Types Comparison : isCOBOL - Micro Focus COBOL - ACUCOBOL-GT - RM/COBOL
  2. How do I interpret file status 9? and other EXFS extended file status codes (e.g. 9i,105)?
  3. What format does isCOBOL use for ORGANIZATION RELATIVE files?
  4. Does isCOBOL support Data General file status codes?
  5. Can I install the UDBC 32 bit on my 64 bit computer in order to have the Veryant * driver for ODBC32 bits Administrator?
  6. Can I call a stored procedure from an isCobol program?
  7. Why do I get the error message “java.lang.ClassNotFoundException: ctree2" ?
  8. Are Veryant's isCOBOL JISAM data format the same as Faircom's c-treeRTG?
  9. Why do I get 'ct_init ERROR 19:133:0' ?
  10. Did you know you can use an alias to map a different disk file name to an existing "assign to" clause of the select statement without source code changes?
  11. Did you know you can encrypt an indexed file?
  12. Handling the extension on indexed data files
  13. How to hide the user and password used to connect to an RDBMS
  14. Can we use Micro Focus format data and indexed files directly or do they need some form of conversion?
  15. How to access files on a different server
  16. How to create, write, and read to files without a program
  17. Managing the order of the alternate keys in an indexed file
Article Information Additional Information
Article Number: 153
Created: 2010-10-28 9:56 PM
Rating: No Rating
 
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.