AS/400 administration, AS/400 backup, 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 performance, AS/400 printing, AS/400 Query, AS/400 security, AS/400 Spool Files, AS/400 Subfiles, AS/400 user profiles, AS400 physical file, BRMS, CL, CL Program, CL programming, CL programs, CL/400, Client Access, CLLE, CLP, COBOL, COBOL/400, 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
How to compare CL character field (year#) with packed decimal field(QRPS)of 3P0 length from file QRBT as equal. Please provide OPNQRYF statement for the same.
I am executing a CLLE program that uses an OPNQRYF to select records from file "FILE1" which is a physical file containing in excess of 1 million records. I only need records with a specific date (about 5000 records) The file is opened for share = *yes and the program calls an RPGLE program that...
I know that %NOT is a function available for using in the qryslt parameter of opnqryf but I can't figure out how to code it. I would like to eliminate all records with a range in the middle of the possible range, for example, select all facilities except those is the range of 600 - 699. Is this...