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

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