Index

A

Access Airspeed, [1] ALIAS_DEFINED test ANSI compatibility Apache Velocity

ARG system variable, [1] Argument variables ASK metacommand Autocommit, [1], [2], [3], [4] AUTOCOMMIT metacommand, [1], [2], [3], [4] AUTOCOMMIT_STATE system variable

B

Batch files, [1] BEGIN BATCH metacommand, [1] BEGIN SCRIPT metacommand, [1], [2], [3], [4] BEGIN SQL metacommand

Bluefish Boolean data types BOOLEAN_INT metacommand BOOLEAN_WORDS metacommand BREAK metacommand

C

CANCEL_HALT metacommand, [1], [2] CANCEL_HALT_STATE system variable Case folding CD metacommand CGI CockroachDB COLUMN_EXISTS test Command-line options, [1], [2] Commit, [1], [2], [3], [4], [5], [6], [7] Conditional execution, [1], [2], [3] CONFIG BOOLEAN_INT metacommand CONFIG BOOLEAN_WORDS metacommand CONFIG CLEAN_COLUMN_HEADERS metacommand CONFIG CONSOLE WAIT_WHEN_DONE metacommand CONFIG CREATE_COLUMN_HEADERS metacommand CONFIG DAO_FLUSH_DELAY_SECS metacommand CONFIG DEDUP_COLUMN_HEADERS metacommand CONFIG DELETE_EMPTY_COLUMNS metacommand CONFIG EMPTY_ROWS metacommand CONFIG EMPTY_STRINGS metacommand CONFIG EXPORT_ROW_BUFFER metacommand CONFIG FOLD_COLUMN_HEADERS metacommand CONFIG GUI_LEVEL metacommand CONFIG HDF5_TEXT_LEN metacommand CONFIG IMPORT_COMMON_COLUMNS_ONLY metacommand CONFIG IMPORT_ROW_BUFFER metacommand CONFIG LOG_DATAVARS metacommand CONFIG LOG_WRITE_MESSAGES metacommand CONFIG MAKE_EXPORT_DIRS metacommand CONFIG MAX_INT metacommand CONFIG metacommand CONFIG ONLY_STRINGS metacommand CONFIG QUOTE_ALL_TEXT metacommand CONFIG REPLACE_NEWLINES metacommand CONFIG SCAN_LINES metacommand CONFIG TRIM_COLUMN_HEADERS metacommand CONFIG TRIM_STRINGS metacommand CONFIG WRITE_PREFIX metacommand CONFIG WRITE_SUFFIX metacommand CONFIG WRITE_WARNINGS metacommand CONFIG ZIP_BUFFER_MB metacommand Configuration, [1] additional configuration files Boolean integers, [1] Boolean words Clean column headers, [1] connect Console height Console wait when done, [1] Console wait when error, [1] Console width Create column headers CSS, [1] DAO flush delay Dedup column headers, [1] Delete empty columns email Empty rows Empty strings, [1] encoding Export row buffer Fold column headers, [1] GUI level HDF5, [1] Import buffer Import common columns, [1] input, [1] interface Log write messages logging data variables Logging write messages Make export directories, [1] Maximum integer, [1] Metacommands Only strings, [1] optional includes output Output file open timeout Quote, [1] Replace newlines, [1] required includes Scan lines Template processor Trim column headers, [1] Trim strings, [1] variables Write prefix Write suffix Write warnings Zip buffer size, [1]

Configuration, Boolean words Configuration, Delete empty columns Configuration, Empty rows Configuration, Export row buffer Configuration, Import row buffer CONNECT metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11] CONSOLE metacommand, [1] Console output, [1] CONSOLE WAIT_WHEN_ERROR metacommand CONSOLE_ON test CONSOLE_WAIT_WHEN_DONE_STATE system variable CONSOLE_WAIT_WHEN_ERROR_STATE system variable CONTAINS test Continuation characters COPY metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12] COPY QUERY metacommand COUNTER system variable, [1], [2], [3], [4], [5] Counter variables, [1] CREATE SCRIPT metacommand CSV files, [1], [2], [3] CURRENT_ALIAS system variable, [1] CURRENT_DATABASE system CURRENT_DATABASE system variable, [1] CURRENT_DBMS system variable, [1] CURRENT_DIR system variable, [1] CURRENT_PATH system variable CURRENT_SCRIPT system variable, [1] CURRENT_SCRIPT_NAME system variable CURRENT_SCRIPT_PATH system variable CURRENT_TIME system variable, [1], [2] CURRENT_UTC_TIME system variable

D

Data entry, [1] Data variables Database name, [1], [2] Database permissions, [1], [2] DATABASE_NAME test DATE_TAG system variable, [1], [2] DATETIME_TAG system variable, [1], [2] DATETIME_UTC_TAG system variable DB_NAME system variable, [1] DB_NEED_PWD system variable DB_SERVER system variable DB_USER system variable, [1] DBMS test DEBUG LOG CONFIG metacommand

DEBUG LOG SUBVARS metacommand DEBUG WRITE CONFIG metacommand DEBUG WRITE ODBC_DRIVERS metacommand DEBUG WRITE SUBVARS metacommand Debugging, [1], [2], [3], [4], [5] Deferred substitution Delete file Delete substitution variable DIALOG_CANCELED test DIRECTORY_EXISTS test DISCONNECT metacommand Documentation DSN, [1], [2] DuckDB, [1]

E

Editors EMAIL metacommand Encoding, [1], [2], [3], [4] Encryption, [1] ENDS_WITH test Environment variables EQUAL test, [1] Error reporting ERROR_HALT metacommand, [1], [2], [3], [4] ERROR_HALT_STATE system variable ERROR_MESSAGE system variable execsql.log EXECUTE metacommand, [1] EXECUTE SCRIPT metacommand, [1], [2], [3], [4], [5] Exit status, [1], [2], [3], [4], [5], [6], [7], [8] EXPORT metacommand, [1], [2], [3], [4], [5], [6], [7], [8] EXPORT QUERY metacommand EXPORT_METADATA metacommand Exporting Airspeed base64-encoded data CGI CSV DuckDB feather file dates, [1] Formatted text, [1] HDF5 HTML Jinja JSON, [1] LaTeX ODS plain text raw data spreadsheets SQLite TAB, [1] template-driven TSV, [1] TXT, [1] US VALUES XML

EXTEND SCRIPT metacommand

F

FILE_EXISTS test

Firebird, [1], [2], [3], [4], [5], [6], [7]

G

Geany Generate SQL

Glossary GUI display, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], [17], [18], [19] gui_level

H

HALT metacommand, [1], [2]

HASROWS test HDF5, [1], [2]

I

IDENTICAL test, [1] IF metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16] IMPORT metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15] IMPORT_FILE metacommand Importing Multiple Worksheets INCLUDE metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12] INSERT metacommand

INSERT...VALUES statement Interactive querying IS_GT test IS_GTE test IS_NULL test IS_TRUE test IS_ZERO test

J

Jinja, [1], [2]

JSON Table Schema

L

LAST_ERROR system variable LAST_ROWCOUNT system variable, [1] LAST_SQL system variable, [1] Local variables, [1]

LOG metacommand, [1], [2] LOG_WRITE_MESSAGES metacommand, [1] Logging, [1], [2], [3], [4], [5], [6], [7] LOOP metacommand Looping

M

MariaDB, [1], [2], [3], [4], [5], [6], [7], [8], [9] Markdown, [1], [2], [3], [4] Message display, [1] METACOMMAND_ERROR test, [1] METACOMMAND_ERROR_HALT metacommand, [1], [2]

METACOMMAND_ERROR_HALT_STATE system variable Metacommands, [1], [2], [3] MS-Access, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13] temporary queries Multi-line messages MySQL, [1], [2], [3], [4], [5], [6], [7], [8], [9]

N

NEWER_DATE test

NEWER_FILE test

O

Obfuscation, [1] ON CANCEL_HALT EMAIL metacommand ON CANCEL_HALT EXECUTE SCRIPT metacommand ON CANCEL_HALT WRITE metacommand ON ERROR_HALT EMAIL metacommand, [1] ON ERROR_HALT EXECUTE SCRIPT metacommand

ON ERROR_HALT WRITE metacommand, [1] Operating system command Oracle, [1] OS system variable Outer-scope referent Output Run Numbering

P

Passwords, [1], [2], [3], [4], [5] PATHSEP system variable PAUSE metacommand, [1], [2] PDF PG_VACUUM metacommand Postgres, [1], [2], [3], [4], [5], [6], [7], [8], [9] PostgreSQL PROMPT ACTION metacommand, [1], [2] PROMPT ASK metacommand, [1] PROMPT COMPARE metacommand PROMPT CONNECT metacommand, [1] PROMPT CREDENTIALS metacommand

PROMPT DIRECTORY metacommand, [1], [2] PROMPT DISPLAY metacommand, [1], [2], [3], [4] PROMPT ENTER_SUB metacommand, [1], [2] PROMPT ENTRY_FORM metacommand, [1], [2], [3] PROMPT MESSAGE metacommand PROMPT metacommand, [1] PROMPT OPENFILE metacommand, [1] PROMPT PAUSE metacommand PROMPT SAVEFILE metacommand, [1] PROMPT SELECT_ROWS metacommand PROMPT SELECT_SUB metacommand, [1], [2], [3], [4], [5], [6], [7] Python libraries PYTHON_EXECUTABLE system variable

Q

Quoting of database objects

R

Recursion see Looping Redshift Remove file Remove substitution variable RESET COUNTER metacommand, [1], [2] RESET COUNTERS metacommand

RESET DIALOG_CANCELED RM_FILE metacommand RM_SUB metacommand ROLE_EXISTS test Rollback Run identifier, [1] RUN_ID system variable, [1], [2]

S

SCHEMA_EXISTS test Script file revision date Script files, [1], [2], [3], [4], [5], [6], [7] Script name, [1], [2], [3], [4], [5] Script path SCRIPT_EXISTS test SCRIPT_LINE system variable SCRIPT_START_TIME system variable SCRIPT_START_TIME_UTC system variable Scripting, [1], [2], [3] SELECT_SUB metacommand, [1], [2], [3], [4], [5] SERVE metacommand Server name, [1] SET COUNTER metacommand, [1] SHEETS_IMPORTED system variable SHEETS_TABLES system variable SHEETS_TABLES_VALUES system variable singe: Configuration Create column headers Spreadsheets, [1], [2], [3] SQL Server, [1], [2], [3], [4], [5], [6], [7], [8], [9] SQL_ERROR test SQLite, [1], [2], [3], [4], [5], [6], [7], [8], [9]

SQLites STARTING_PATH system variable STARTING_SCRIPT system variable STARTING_SCRIPT_NAME system variable STARTING_SCRIPT_REVTIME system variable STARTS_WITH test SUB metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14] SUB_ADD metacommand SUB_APPEND metacommand SUB_DECRYPT metacommand SUB_DEFINED test SUB_EMPTY metacommand SUB_EMPTY test SUB_ENCRYPT metacommand SUB_INI metacommand SUB_LOCAL metacommand SUB_QUERYSTRING metacommand SUB_TEMPFILE metacommand, [1], [2], [3], [4] SUBDATA metacommand, [1], [2], [3], [4], [5] Substitution variables, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27], [28], [29] System variables, [1] SYSTEM_CMD metacommand, [1], [2], [3] SYSTEM_CMD_EXIT_STATUS system variable

T

Tab-delimited text, [1] TABLE_EXISTS test, [1] Temporary files, [1] Temporary queries

tilde TIMER metacommand, [1] TIMER system variable Timer variable, [1]

U

Unicode Unit separator Upsert

USE metacommand, [1], [2], [3], [4], [5], [6] User name, [1], [2], [3], [4] USER system variable, [1] UUID system variable

V

Vacuum Variable evaluation

VERSION system variables VIEW_EXISTS test Vim

W

WAIT_UNTIL metacommand WRITE CREATE_TABLE metacommand, [1] WRITE metacommand, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11]

WRITE SCRIPT metacommand write_prefix write_suffix write_warnings

X

XML

Z

ZIP metacommand