Join files

[wjminc]

I have a Logical file that is created from joining two Physical files. I now need to add a field from each file that has the same name (DATE). How can I add these to the joined file? Thanks for any and all help. William..

[B.Myrick]

William, Unless I'm mistaken (again), you need to edit the join file source member, delete the join file object and then recreate the joined file from the new source member. Hope this helps, Bret Myrick

[wjminc]

Bret, I have tried that, but keep getting the error message: CPD5237 - Field or ALIAS name specified more than once in record. Example of my DDS: jdftval r lotal01 jfile(lotuu lotop) j join(1 2) jfkd(lotno lotno) lotno jref(1) outlot jref(2) custpo jref(1) custpo jref(2) ** this gives me the error. Thanks, William..

[S.Mildenberger]

Try this: custpo2 jref(2) rename(custpo) Not positive it will work but it just might.

[B.Myrick]

William, I think (THINK) the problem is the field name CUSTPO being used from two different files. I THINK you should use the dds keyword ALIAS on the second (or first if you prefer) iteration of the field CUSTPO. The programs that read this join file will now reference the ALIAS name instead of CUSTPO when referencing file two. A CUSTPO ALIAS(CUSTP2) This cannot be used on a key field. If for a key field, perform the ALIAS and then reference the ALIAS name in the key specification. If not for a key field, the ignore this paragraph. Let me know, Bret Myrick

[wjminc]

Scott, Your example worked great. Was what I was looking to do. Thanks, Willie..