Thanks for everyone for all their comments and feedback on the abovecan you help me with the same error, i'm beginner inSCO UNIX...
error. Here's a summary:
Error:
245: Could not position within a file via an index.
103: ISAM error: illegal key descriptor (too many parts or too long).
I was getting this error when running a query inside a stored procedure,
but outside the stored procedure, the query ran fine.
The solution to the case in which I saw this error was to run
'update statistics' on the table. This seemed to get rid of the reason
why I was having the error. I don't know really why the error occured.
The other suggestions I received were:
1. Try oncheck (or tbcheck depending on version) with -cID
2. Re-create the procedure from fresh
3. Use update statistics on the procedure and on the table
4. Problem could be caused by locks
5. Try using an sqexplain.out file
6. Use dirty reads (if applicable)
7. Try determinining which index path it uses (in sysindexes)
Thanks -----------------------------------------------------------------------
Allan Gould EMAIL : all...@sco.com
Technical Support Engineer
SCO Ltd SUPPORT PHONE : +44 (0)113 251 2222
Vision House, Waterside, SUPPORT FAX : +44 (0)113 251 2223
Kirkstall Rd, Leeds
LS4 2QB MAIN PHONE: : +44 (0)113 251 2000
England MAIN FAX: : +44 (0)113 251 2001 -----------------------------------------------------------------------
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 343 |
Nodes: | 16 (3 / 13) |
Uptime: | 31:23:35 |
Calls: | 7,557 |
Calls today: | 1 |
Files: | 12,733 |
Messages: | 5,655,716 |