Hi,
I want to write an equivalent RPGLE Program to generate a physical file and logic wise it should have same records genereated in file3 after using file1 and file2 like below SQL query.
Any idea how can we write the equivalent RPGLE program for the same?
select * from file1 where fld1='ABCDEF' and fld2= (int(current date) - 19000000) and fld3 in (select fld7 from file2 where fld8='1') and fld4 in ('TYM','IOP')
where fld1,fld2,fld3,fld 4 are from file1 and fld7, fld8 are from file2.
Please Note:- fld2 is that specific numeric field having a numeric type and a length of 7 and which has a date field in it in CYY/MM/DD format ( as in the DDS of the file Edit word with slashes have been defined in it's definition part length 7 with packed data type ) in which we want to have all
the records for current system date.
So How can we write an equivalent RPGLE program to generate a physical file which has same data which is generated from above SQL query?
Thanks....
I want to write an equivalent RPGLE Program to generate a physical file and logic wise it should have same records genereated in file3 after using file1 and file2 like below SQL query.
Any idea how can we write the equivalent RPGLE program for the same?
select * from file1 where fld1='ABCDEF' and fld2= (int(current date) - 19000000) and fld3 in (select fld7 from file2 where fld8='1') and fld4 in ('TYM','IOP')
where fld1,fld2,fld3,fld 4 are from file1 and fld7, fld8 are from file2.
Please Note:- fld2 is that specific numeric field having a numeric type and a length of 7 and which has a date field in it in CYY/MM/DD format ( as in the DDS of the file Edit word with slashes have been defined in it's definition part length 7 with packed data type ) in which we want to have all
the records for current system date.
So How can we write an equivalent RPGLE program to generate a physical file which has same data which is generated from above SQL query?
Thanks....
Comment