Columns: You may select columns from the specified tables, views, physical files, and aliases.Objects: You may prompt tables, views, MQTs, aliases, physical and logical files, and aliases from within SQL statements.Commands: You may prompt the most commonly-used standard SQL commands, such as SELECT, INSERT, and UPDATE.
What Is Content Assist?Ĭontent Assist is a prompter for SQL commands on different levels: Not to mention the typos!įortunately, this pain ended with the introduction of Content Assist in the ACS Run SQL Scripts facility. You will agree, for complex queries copy and paste could get a little sophisticated. After finding the appropriate information, we had to copy or type the database object and column names by hand. Alternatively, we could run queries against the SYSTABLES and SYSCOLUMNS views to find database object names and/or column names. We also needed to know in which schemas (libraries) our database objects were located. To access tables, views or materialized query tables (MQTs), we needed to know the names of our database objects and columns. In ACS version 1.1.8.3, Content Assist includes prompting for SQL statements.īefore ACS Version 1.1.8.3, no prompting was available within the Run SQL Scripts Facility. The common excuse has been that the Run SQL Script facility does not include a way to prompt SQL commands, tables, and columns. Others use third-party tools to execute SQL statements. Nevertheless, many SQL users still prefer this legacy interface over the Access Client Solutions (ACS) Run SQL Scripts facility. STRSQL, the green-screen facility for executing SQL Statements, has had its days. Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL!
0 kommentar(er)
