Re: ACS run sql scripts content assist on v5r4

[Peter Dow <petercdow@xxxxxxxxx>]

Same result, whether positioning the cursor before the asterisk or 
highlighting it. It says "No database proposals".


On 10/23/2021 5:34 AM, Birgitta Hauser wrote:
> Highlight the asteric and then press control space.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: MIDRANGE-L<midrange-l-bounces@xxxxxxxxxxxxxxxxxx>  On Behalf Of Peter Dow
> Sent: Samstag, 23. Oktober 2021 03:37
> To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: ACS run sql scripts content assist on v5r4
>
> I haven't had much opportunity to use Run SQL Scripts in ACS.
>
> I had a simple SQL statement:
>
> SELECT * FROM myFile;
>
> positioned the cursor at the * and pressed ctl-space.  It pops up a window with syntax proposals. After fiddling around awhile, I finally noticed the little text at the bottom of the window saying "ctl-space switch to database proposals".  I did that, and it tells me "No database proposals".
>
> I ran the SQL statement, and it ran just fine, showing all the fields.
> So I tried content assist again, and it still says "No database proposals".
>
> Tried again on a v7r3 box, and voila! it worked - I got a list of fields.
>
> My question is, why doesn't it work on a v5r4 box?  My guess is that instead of ACS doing the work of getting the list of fields from SYSTABLES, it depends on the OS to have it stored somewhere like maybe the SQL package or as some part of the table object.
>
> --
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> petercdow@xxxxxxxxx
> pdow@xxxxxxxxxxxxxx
>
> /