]]>The post AS/400: Joining multiple files and getting multiple duplicates appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/joining-multiple-files-and-getting-multiple-duplicates/feed/5AS/400 Query Join Duplicate Recordshttp://itknowledgeexchange.techtarget.com/itanswers/as400-query-join-duplicate-records/
http://itknowledgeexchange.techtarget.com/itanswers/as400-query-join-duplicate-records/#commentsWed, 30 Dec 2009 13:27:00 +0000I have three files A, B, C in my join query. Test is between A – B, B – C. The type is 2 (match records to primary file). When I run the query, it is returning duplicates. What am I doing wrong?

]]>http://itknowledgeexchange.techtarget.com/itanswers/as400-query-join-duplicate-records/feed/2AS/400: concept of Unique keyhttp://itknowledgeexchange.techtarget.com/itanswers/as400-concept-of-unique-key/
http://itknowledgeexchange.techtarget.com/itanswers/as400-concept-of-unique-key/#commentsWed, 16 Dec 2009 04:50:19 +0000Hi, I have a PF wiht 3 fields. I created LF based on this PF, with first 2 fields as Key fields and specify file level key work UNIQUE in that LF. What will happend if I add the duplicate records in PF object…?

]]>http://itknowledgeexchange.techtarget.com/itanswers/as400-concept-of-unique-key/feed/2Duplicated Fileshttp://itknowledgeexchange.techtarget.com/itanswers/duplicated-files-2/
http://itknowledgeexchange.techtarget.com/itanswers/duplicated-files-2/#respondTue, 02 Dec 2008 19:21:45 +0000Hi friends, I have a System (AS/400) and on this server i have many and many files with the same name , example: I have the file FILEX on LIB1, FILEX on LIB2, FILEX on LIB3 , etc ….. I Run the command DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(LIBTEST/FILETEST). Now, How can I run a Query...