I am using the same id as when I log into the iSeries directly and run the query in STRSQL, which produces the result above. I'll ask my more i-series knowledegable colleagues. Thanks for your advice so far
The file used in the query, CSVLLSP, is in 4 libraries in my list, and the above query works on each, returns the expected result, not an empty list. My colleague is having the same problem in Atrium. His lib list is ordered somewhat differently but the file exists in each lib and returns the expected result for the query. But the dropdowns are empty. What is the next question to ask in solving this? Thanks.
Beats me... I have no idea how this is causing you problems. Please create a support ticket with Profound Logic. The support team will work with you to figure out how we can reproduce it on our end so that we can troubleshoot/fix the problem.
It'll be really important for us to figure out how to make it happen on our own box. (We'll need to be able to debug the code, which we cannot do unless we can reproduce it.)
Actually, I'll have support contact you about this.
Thanks. If your test suite doesn't include it, perhaps support could begin by testing an example with an expression in the choice options field like our.
choices options field (CASE SUBSTR(INTVAL,1,1) WHEN ' ' THEN ''' ''' ELSE INTVAL END) || ':' || CNDTXT
Your problem (which required using the EBCDIC setting) was the use of the || for concatenation. Try using the keyword CONCAT in it's place and you should be able to avoid the problem.