i want to create a new result field by concatinating two or more fields in OPNQRY for comparision.
I have one tranaction file having millions on records however i want only records which were trasacted in last twodays.
I have 3 seperate fields in trans file as TRYEAR, TRMONTH, TRDAY for transaction date.
i am receiving 2 dates into my cl program
1. one is last cycle processed date (20090720) &
2. current cycle date (20090722)
now i want to write OPNQRYF on my transaction file to select records between these two dayes 20090721 and 20090722.
i have one RPGLE program to process records which ever selected in OPNQRYF.
Can any one please help how can code this one in OPNQRYF.
July 22, 2009 11:41 AM
July 24, 2009 10:00 PM