OPNQRYF Has No “If” But You Can Fake It
November 5, 2008 Hey, Ted
We recently started adding Web customers to our customer master file, in which a customer ID is a field of seven characters. The ID’s of Web customers consist of the letter “W” followed by six digits. Is there any way using OPNQRYF to change only the customer IDs that start with “W” to the customer number “5000000” for reporting purposes? Doing so would allow us to keep a lot of existing programs running without a lot of modification. –John OPNQRYF does not have conditional logic, John, but in your case, you can fake it out. Here’s the type of OPNQRYF |