AS/400 Query Join Duplicate Records
I 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?

Answer Question   |  December 31, 2009  1:27 PM
AS/400 Duplicate Files, AS/400 Query, AS/400 Records

AS/400: concept of Unique key
Hi, 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…?  

Answer Question   |  December 16, 2009  4:50 AM
AS/400, AS/400 Duplicate Files, Physical Files, Unique key

Duplicated Files
Hi 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 [...]

Answer Question   |  December 2, 2008  7:21 PM
AS/400, AS/400 Duplicate Files, AS/400 Query