Highlight the asteric and then press control space.
Mit freundlichen Grüßen / Best regards
"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)
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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.