|
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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.