AS/400 administration, AS/400 backup, AS/400 command functions, AS/400 commands, AS/400 database, AS/400 DB2, AS/400 development, AS/400 error messages, AS/400 errors, AS/400 FTP, AS/400 jobs, AS/400 objects, AS/400 performance, AS/400 printing, AS/400 Query, AS/400 security, AS/400 Spool Files, AS/400 Subfiles, AS/400 user profiles, BRMS, CL, CL Program, CL programming, CL programs, CL/400, Client Access, CLLE, CLP, COBOL, DDS, i5, i5/OS, IFS, iSeries, iSeries RPG programming, iSeries V6R1, OS/400, Physical File, PTFs, RPG, RPG ILE, RPG/400, RPGILE, RPGLE, Spool files, SQLRPGLE, Subfile, V5R3, V5R4, V6R1 VIEW ALL TAGS
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?
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...?
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...