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
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
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