sqlmc_script_complete: Parameters
maxItems has a default because a caret at the start of a statement offers the whole dialect —hundreds of keywords — and everything past the first screenful is noise an agent pays for by thetoken.
caretOffset |
Required. Zero-based character offset of the caret. May equal the text's length |
sql |
The script text. Give this or path, not neither |
path |
A .sql file to read the text from, when sql is not given |
workspace |
The .smcworkspace, or a folder holding one. Resolved automatically when omitted |
connection |
Name or id of the registered connection whose schema resolves names here |
database |
Database to resolve against, when it is not the connection's own |
distributionList |
Target group whose last coverage scan annotates the items |
maxItems |
Most items to return, best first. Defaults to 50 |
maxItems has a default because a caret at the start of a statement offers the whole dialect —
hundreds of keywords — and everything past the first screenful is noise an agent pays for by the
token. The engine ranks best-first, so a cap keeps what is worth having.