LIST not working on one file only (AREV Specific)
At 04 APR 2005 05:13:02PM Sadhana wrote:
Trying LIST filename at TCL and it returns with "SEQ is an unrecognized word". Only happens with this one file. Somehow LIST is interpreted as SEQ with this file only. LISTDICT on same file works fine. Using 2.12.
Thanks.
At 04 APR 2005 05:16PM Matt Sorrell wrote:
When you LIST the table, are you specifying any columns? Check to see if there is an @CRT dictionary item for the table. If so, check any of the columns to see if they are symbolic and make sure there is not a problem with one of them.
Also, try doing a 'LIST @ID F1 F2' and see if that works. F1 and F2 are defined in DICT.VOC and are globally available. They will return fields 1 and 2, respectivelly. If this works, then I'm really thinking there is a symbolic field included in @CRT that is going crazy.
Finally, if there is an @CRT defined, specify the fields manually and see if it still blows up. Remove the fields one at a time until it stops dying. The last field removed should be the offending field. Conversely, you can add the fields one at a time (or a perform a list with each field singly) to try and identify the culprit.
HTH (but not HHGTTG yet:),
At 04 APR 2005 05:40PM Warren Auyong wrote:
Check the @CRT and @LPTR group records in the dictionary.
At 05 APR 2005 11:14AM Sadhana wrote:
@CRT in dictionary was showing "SEQ C.1 C.2 C.3" and so on. Got rid of that and it works. Don't think anything was assigned in there previously. Had done a Group Fix and compress Overflow frames on file before getting this error so wonder if that had anything to do with @CRT.
Thanks.