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
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.
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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.