Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EGL Development Tools » Library From Database problem(Generates definitions with a lot of errors.)
Library From Database problem [message #924314] Wed, 26 September 2012 14:41 Go to next message
Bob NIcholson is currently offline Bob NIcholson
Messages: 62
Registered: December 2011
Location: Seattle
Member
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
Re: Library From Database problem [message #924393 is a reply to message #924314] Wed, 26 September 2012 16:18 Go to previous messageGo to next message
Joseph Vincens is currently offline Joseph Vincens
Messages: 31
Registered: December 2011
Location: Prospect CT
Member
Hi Bob,

You should open a defect. The wizard field name validation used to build the record needs to be updated to add a @Column for this condition.

regards,
Joe
Re: Library From Database problem [message #924428 is a reply to message #924393] Wed, 26 September 2012 16:57 Go to previous message
Bob NIcholson is currently offline Bob NIcholson
Messages: 62
Registered: December 2011
Location: Seattle
Member
Hi,Joe

I also feel this is a bug. I've submitted it as a problem.
Previous Topic:JDBC driver error message from EGL on Tomcat 6 on iSeries
Next Topic:Mobile widgets
Goto Forum:
  


Current Time: Tue Jul 22 07:32:33 EDT 2014

Powered by FUDForum. Page generated in 0.02950 seconds