Re: 245: Could not position within a file via an index: Summary

[Yadira Arias González]

El miércoles, 6 de noviembre de 1996 a las 2:00:00 UTC-6, Allan Gould escribió:
> Thanks for everyone for all their comments and feedback on the above
> 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
> -----------------------------------------------------------------------
can you help me with the same error, i'm beginner inSCO UNIX...