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

/

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-2022 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.