- 论坛徽章:
- 0
|
找到方法了:
1,import the the data from journal
DSPJRN JRN(KENT/ECLJRN) FILE((BPCSF/ECL)) RCVRNG(KENT/ECLJRN0041)
FROMTIME('19/12/13' 010101) TOTIME('19/12/13' 010101) ENTTYP(UP UB)
OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(KENT/AAA) ENTDTALEN(881)
2, copy the orignal file
CPYF FROMFILE(BPCSF/ECL) TOFILE(KENT/BBB) CRTFILE(*YES) TORCD(1)
3, clear the copied file
delete from kent/bbb
4, create a view
CREATE VIEW kent/ccc AS
SELECT JOESD FROM kent/aaa
5, copy the data from the view to the copied file
CPYF FROMFILE(KENT/CCC) TOFILE(KENT/BBB) MBROPT(*ADD) FMTOPT(*NOCHK) |
|