16. Reference
16. Reference
A comprehensive reference for precise definitions of syntax, functions, configuration, and system catalogs. For SDK/API documentation, see Chapter 11, Development and Application Integration. For concepts and examples, see the relevant feature chapter.
Contents
| Section | Description |
|---|---|
| SQL Reference | SQL syntax, functions, data types, hints, and relative time expressions |
| Configuration Reference | machbase.conf properties and dynamically configurable properties |
| Command-line Tools | Options for CLI tools such as machsql, machadmin, and machloader |
| Development Tool Integration | Go, Python, Java, and C client SDK/APIs (Chapter 11) |
| System Catalog | V$ and M$SYS views and column descriptions |
| Error Codes | Error numbers, messages, causes, and corrective actions |
| Support Scope and Constraints | Feature support by table type and known constraints |
| AI Agent Reference | AI/RAG navigation guides, canonical maps, and LLM outputs |
Finding Information
- Check syntax → SQL Syntax Dictionary
- Function arguments and return values → SQL Function Dictionary
- Data type ranges and defaults → Data Type Dictionary
- Setting meanings and allowed ranges → Configuration Reference
- Diagnose error causes → Error Codes
For behavior, selection criteria, and operational guidance, see the relevant feature chapter.
Last updated on