LEFT OUTER JOINS
Posted: Fri Oct 22, 2004 7:23 am
Greetings. I need to do a left outer join in DB2 API and use a between date range, example;;
key1 = key2 and date1 between date 2 and date3. I keyed the join into the api stage and it worked in the viewer but the osh abends when I attempt to run it. I then attempted the join stage but do not seem to be able to put in the logic for the between condition. Any ideas?
THX
key1 = key2 and date1 between date 2 and date3. I keyed the join into the api stage and it worked in the viewer but the osh abends when I attempt to run it. I then attempted the join stage but do not seem to be able to put in the logic for the between condition. Any ideas?
THX