VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

[johnod33]

Has anyone run into this error? I am creating and holding two tables. The first table runs ok and the second table appears to get created (lines has a value) but then it crashes. There is no join on this second table.

0 NUMBER OF RECORDS IN TABLE= 865 LINES= 865

0 HOLDING...
0 HOLDING...
1
0 NUMBER OF RECORDS IN TABLE= 828843 LINES= 828843
0
(FOC1070) VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED

Funny thing is it worked fine for a long time and all of a sudden it comes up with this error. You can probably tell I am new to Web Focus

John O'D

 

[jimster06]

Do a CHECK FILE filename PICTURE to determine if there is a cross-referenced segment in the file. This may help find the problem.

HTH

 

[mrguru]

Check the .mas of the second file. Does it create a foclist field. If so, it will blow up at 100000. Try adding this to your focexec:

SET COUNTWIDTH = ON

It will increase this to 999999999.

 

[johnod33]

What I did was added a Focus index :
FORMAT FOCUS INDEX
to my hold table line:
ON TABLE HOLD AS TEMPHOLDTABLE FORMAT FOCUS INDEX ITEM
and no more error !
Yahoo !
John O'D

 

[focwizard]

That's the best way.

What causes the error is the following:

When you JOIN to a sequential file, you have no 'direct' access method (no index). So, we move FORWARD in the file only. This means that both the source and the target MUST be in ascending order, based on the common field. It also implies that you CANNOT have duplicate values in BOTH files. If you have them in the source file, you can only do a UNIQUE JOIN. If you have duplicates in the target, then you can have either a UNIQUE or non-unique JOIN (a uniques JOIN will only retrieve the first matching instance). If you have duplicate values in BOTH files, you get this error, since, once the first of the duplicates in the source file is processed, to process the next duplicate value of the source, we'd have to back up in the target, which we don't do.