Description Bob NIcholson 2012-09-26 16:49:17 EDT

I'm not sure I've got the correct component specified for this. It's the wizard.

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:
[code]
@@CHC     
@@ABO     
@@CHC_P   
CHCSEQ    
CHC       
CHCMNC    
PROTECT   
CUAMDL    
IOOVR     
CHCSEL    
@@ABASEL  
CHCMSGID  
[/code]

The generated record in EDT looks like below causing errors for each field starting with "@@":
[code]
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

[/code]

Should this not look more like the following (replacing the invalid field names) which would prevent the errors:

[code]
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
[/code]



Thanks

Bob