× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.