Re: SQL5011 again, stranger things -- Anybody here from IBM here, decipher this cryptic error msg?

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

Thank you Glenn. Another couple of changes and the issue resolved 
itself, and I still don't know how or even what the issue was.

Thank you for your help.

--Alan


On 9/29/2022 10:31 AM, Alan Cassidy wrote:
> I'll post a "safe" version of it in a little while. I'm in the middle 
> of something right now....
>
> --Alan
>
> On 9/29/2022 9:52 AM, Glenn Gundermann wrote:
> > Out of curiosity, can you post the code?Yours truly,Glenn 
> > Gundermannglenn.gundermann@xxxxxxxxx(416) 317-3144---
> > -------- Original message --------From: Alan Cassidy 
> > <cfuture@xxxxxxxxxxx> Date: 2022-09-29  9:02 a.m. (GMT-05:00) To: 
> > rpg400-l@xxxxxxxxxxxxxxxxxx Subject: Re: SQL5011 again, stranger 
> > things -- Anybody here from IBM here, decipher this cryptic error 
> > msg? By the way, that error is blocking the CREATE OR REPLACE script 
> > that creates the View. It's not happening with the embedded SQL in 
> > RPG that creates the cursor I  use to input it.--Thanks againAlan 
> > CassidyOn 9/29/2022 8:39 AM, Alan Cassidy wrote:> I went down the 
> > list of 91 columns one by one to check for whether it > might result 
> > in nulls, and I did find one, so thanks for that, Glenn!>> However, 
> > I'm still getting the same message>> SQL5011  30    3137 Position 58 
> > Host structure array MX not defined > or not usable. Reason: Elements 
> > of the host structure array are  not > contiguous.>> Thank you!>> 
> > Alan Cassidy>>> On 9/28/2022 7:04 PM, Alan Cassidy wrote:>> That's a 
> > good question, Glenn.>>>> I don't think so, I've used the same exact 
> > code with the same (almost >> exact, I think) list of fields from a 
> > bunch of different files in the >> View.>>>> But that's a good lead 
> > and I'm going to check it out. I have a >> practice of always using 
> > clauses in the column list that turn nulls >> into zeros or blanks. 
> > Maybe I missed one or changed something in >> trying to make the 
> > program work properly. The programmer that >> developed this just 
> > used almost all DCL-F specs and put lots of code >> matching things 
> > up. I've rolled a huge chunk of that code into this >> View.>>>> 
> > Thanks!>>>> Alan>>>>>> On 9/28/2022 6:36 PM, Glenn Gundermann 
> > wrote:>>> Hi Alan,Are any of the fields nullable. Do you need null 
> > >>> indicators?Yours truly,Glenn >>> 
> > Gundermannglenn.gundermann@xxxxxxxxx(416) 317-3144--->>>> > -------- 
> > Original message --------From: Alan Cassidy >> <cfuture@xxxxxxxxxxx> 
> > Date: 2022-09-28  6:12 p.m. (GMT-05:00) To: >> 
> > rpg400-l@xxxxxxxxxxxxxxxxxx Subject: SQL5011 again, stranger 
> > things>>>> > Good day,I'm getting our seemingly favorite error 
> > again:SQL5011  >> 30    3137  Position 58 Host structure array MX not 
> > defined or >> not                      usable. Reason: Elements of 
> > the host >> structure array are                      not 
> > contiguous.>>>> Now that makes all kinds of sense (not!!) because MX 
> > is an externally >> described data-structure array:        DCL-DS MX 
> > Likeds(MT) dim(5000) >> inz  ;>>>>>> > Anybody come across this one? 
> > Anybody have any ideas?I got help >> once with an SQL5011 error 
> > before and this forum helped me solve it. >> But that text is very 
> > different...--Alan Cassidy-->>>>>>>>> This is the RPG programming on 
> > IBM i (RPG400-L) mailing listTo post >>> a message email: 
> > RPG400-L@lists.midrange.comTo subscribe, >>> unsubscribe, or change 
> > list options,visit: >>> 
> > https://lists.midrange.com/mailman/listinfo/rpg400-lor email: >>> 
> > RPG400-L-request@lists.midrange.comBefore posting, please take a >>> 
> > moment to review the archivesat >>> 
> > https://archive.midrange.com/rpg400-l.Please contact >>> 
> > support@xxxxxxxxxxxxxxxxxxxx for any subscription related >>> 
> > questions.Help support midrange.com by shopping at amazon.com with 
> > >>> our affiliate link: https://amazon.midrange.com-- This is the RPG 
> > programming on IBM i (RPG400-L) mailing listTo post a message email: 
> > RPG400-L@lists.midrange.comTo subscribe, unsubscribe, or change list 
> > options,visit: https://lists.midrange.com/mailman/listinfo/rpg400-lor 
> > email: RPG400-L-request@lists.midrange.comBefore posting, please take 
> > a moment to review the archivesat 
> > https://archive.midrange.com/rpg400-l.Please contact 
> > support@xxxxxxxxxxxxxxxxxxxx for any subscription related 
> > questions.Help support midrange.com by shopping at amazon.com with 
> > our affiliate link: https://amazon.midrange.com