×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

(OP)
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

RE: VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

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

RE: VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

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.

RE: VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

(OP)
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

RE: VALUE FOR JOIN 'FROM' FIELD OUT OF SEQUENCE

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close