AS/400 administration, AS/400 backup, AS/400 Client Access, AS/400 command functions, AS/400 commands, AS/400 database, AS/400 development, AS/400 Display File, AS/400 error messages, AS/400 errors, AS/400 FTP, AS/400 job scheduler, AS/400 jobs, AS/400 objects, AS/400 performance, AS/400 printing, AS/400 Query, AS/400 Records, AS/400 security, AS/400 Spool Files, AS/400 user profiles, CL, CL Program, CL programs, CL/400, Client Access, CLLE, CLP, DB2/400, DDS, i5, i5/OS, IFS, iSeries, iSeries Navigator, iSeries printing, iSeries RPG programming, iSeries V6R1, OS/400, Physical File, PTFs, RPG, RPG ILE, RPG/400, RPGILE, RPGLE, Spool files, V5R3, V5R4, V6R1 VIEW ALL TAGS
We do a recocciliation of input and processed output file. There is always instances where we have same primary key with 2 same different values in the output and input file. When i do amatching query, it returns 4 variances instead of just showing 2 variances of zero amounts. It shows extra 2...
Is there a way to globally change the libraries of the input files for a set of AS400 Queries, or possible force it to use *libl. I know that I entered *libl for the file selection, but it then defaults to a specific library.