Hi

I have code for join file:

A R Irecord JFILE(File1 File2)
A TEXT('JF - ITEM LEDGER + ITEM +
A BRANCH ) ')
A J JOIN(1 2)
A JFLD(File1Field1 File2Field1)
A JFLD(File2Field1 File2Field2)
and then list of fields from both files.

When I creating it with command:


File . . . . . . . . . . . . . . > FileJoin Name
Library . . . . . . . . . . . > LIB Name, *CURLIB
Source file . . . . . . . . . . > Filesrc Name
Library . . . . . . . . . . . > Lib Name, *LIBL, *CURLIB
Source member . . . . . . . . . > FileJoin Name, *FILE
Generation severity level . . . 20 0-30
Flagging severity level . . . . 0 0-30
File type . . . . . . . . . . . *DATA *DATA, *SRC
Member, if desired . . . . . . . *FILE Name, *FILE, *NONE
Physical file data members:
Physical file . . . . . . . . *ALL Name, *ALL
Library . . . . . . . . . . Name, *CURRENT
Members . . . . . . . . . . . Name, *NONE
+ for more values

I get command

Job 531353/USER/FileJoin ended abnormally.

Then I look at spool and at the end of spool I can see:

* CPC7301 00 Message . . . . : File FileJoin created in library Lib.

And file exist - right but without any members - when I try to run RUNQRY command on it I get:
No members in file FileJoin in Lib.

Why system created join file without member though :

Member, if desired . . . . . . . *FILE Name, *FILE, *NONE

???

Regards

Tomasz SkorÅa





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.