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-2025 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 copyright@midrange.com.

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.