|
Just a guess...but the precompiler is not care as long as the multi-dimensional array is not used as a host variable. I'm not saying don't ask them to improve. I'll give IBM the benefit of the doubt on "what the big deal is"... I can't count the times I've heard that...as programmers I doubt that there is anyone who hasn't had to fight this battle... What sounds easy...is not always easy...sometimes it's a frigging bear & you're breakfast.... Thanks, Tommy Holden -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx Sent: Monday, October 10, 2005 3:38 PM To: RPG programming on the AS400 / iSeries Subject: RE: SQL finally "free'd"??? Might have to; providing the precompiler doesn't gag because, even though it doesn't use them, you have a multidimensioned array defined somewhere. Still, that doesn't preclude me from asking for them to improve. After all I still don't understand what the big deal is. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com "Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 10/10/2005 03:22 PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> cc Fax to Subject RE: SQL finally "free'd"??? Geez...I think the answer has been given...it ain't happening anytime soon...until then work-around...we always do ;-) Exec sql fetch c1 into :myworkvar MyDivision(x).MyPlant(y).MyLocation(z)=myworkvar; If you can't beat 'em .... Join 'em LOL Thanks, Tommy Holden -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx Sent: Monday, October 10, 2005 3:10 PM To: RPG programming on the AS400 / iSeries Subject: RE: SQL finally "free'd"??? So what you are saying is that if my host array in RPGLE is MyDivision(x).MyPlant(y).MyLocation(z) I may have to change it to some format like exec sql fetch c1 into:.....; where ..... may be a totally reformatted MyDivision(x).MyPlant(y).MyLocation(z)? and then you'll take this reformatted variable and do something like >C Z-ADD -4 SQLER6 >C CALL SQLROUTE >C PARM SQLCA >C PARM SQL_00006 >C SQL_00009 IFEQ '1' >C EVAL ...TotallyReformattedVariable... = SQL_00011 Won't that make it hard to find where the variable is used in the EXEC SQL if it won't match the format of the variable in the RPGLE? Or were you thinking of getting the RPG compiler people to change the layout of subscripting arrays? Or is the change simply in the C specs generated by the precompiler and you have to make sure that the generated RPG's >C EVAL ...TotallyReformattedVariable... = SQL_00011 matches some SQL standard? Now I am really confused. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com Gina M Whitney <whitneyg@xxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 10/10/2005 02:07 PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To rpg400-l@xxxxxxxxxxxx cc Fax to Subject RE: SQL finally "free'd"??? >>But, are there really SQL standards on how host variables in imbedded SQL >>can be constructed? >>And, if there are, should we care? I really can't see porting SQLRPGLE to >>other platforms. What you are asking for would require a syntax change. Changing the syntax would affect all languages. Other languages do have a lot of porting. So we would need to agree on a standard way of subscripting arrays and of how many levels of qualifications to accept. This syntax change would also affect all the precompilers. Overall, a lot of code would have to be changed. Gina
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.