When I try to create a library from an iSeries database, the results are generated with a lot of errors. It appears this is because of the way the fields are named on the iSeries.
I'm missing something? The way this appears to be done requires a lot a manual work to clean it up.
Record field names on the iSeries:
@@CHC
@@ABO
@@CHC_P
CHCSEQ
CHC
CHCMNC
PROTECT
CUAMDL
IOOVR
CHCSEL
@@ABASEL
CHCMSGID
The generated record in EDT looks like below causing errors for each field starting with "@@":
record Yabochcrfp type Entity { @table { name="YABOCHCRFP" } }
@@chc decimal(7);
@@abo decimal(7);
@@chc_p decimal(7);
chcseq decimal(3);
chc string(25);
chcmnc string(1);
protect string(1);
cuamdl string(1);
ioovr string(1);
chcsel string(1);
@@abasel decimal(7);
chcmsgid string(7);
chcmncmsid string(7);
chctxov string(1);
bmpval string(1);
bmpname string(12);
end
Should this not look more like the following (replacing the invalid field names) which would prevent the errors:
record Yabochcrfp type Entity { @table { name="YABOCHCRFP" } }
__chc decimal(7) {@Column {name="@@chc"}};
__abo decimal(7) {@Column {name="@@abo"}};
__chc_p decimal(7) {@Column {name="@@chc_p"}};
chcseq decimal(3);
chc string(25);
chcmnc string(1);
protect string(1);
cuamdl string(1);
ioovr string(1);
chcsel string(1);
__abasel decimal(7) {@Column {name="@@abasel"}};
chcmsgid string(7);
chcmncmsid string(7);
chctxov string(1);
bmpval string(1);
bmpname string(12);
end
Thanks
Bob
] 
Search
Help
Register
Login
Home
