YDBDBMS Grammar Documentation

• Introduction
  • Launching Octo
    • Launching Options
      • Verbose
      • Dry-run
      • Input-file
      • -k
• DBMS Grammar
  • CREATE
    • Accepted Data Types
      • Character Data Types
      • Numeric Data Types
    • Mapping to existing YottaDB global variables
  • DROP
  • SELECT
    • Sorting
    • Joins
  • INSERT
  • UPDATE
  • DELETE
  • Set Operations
    • UNION
    • INTERSECT
    • EXCEPT
  • CASE
  • SET
  • SHOW
  • Operators
  • Functions
    • Adding Functions into Octo
  • Considerations
    • Empty string and NULL
  • Technical Notes
• Rocto
  • Connecting to SquirrelSQL
• Error Messages
  • Error Message Severities
  • Octo Errors
    • BAD_ADDRESS
    • BAD_CONFIG
    • BUFFER_TOO_SMALL
    • CLIENT_CONNECTED
    • CURPLAN
    • DATABASE_FILES_OOS
    • ENTERING_FUNCTION
    • FAILED_TO_PARSE_SCHEMA
    • FEATURE_NOT_IMPLEMENTED
    • FILE_NOT_FOUND
    • GENERATING_TEMPORARY_TABLE
    • INIT_SCANNER
    • INVALID_READ_SIZE
    • INVALID_WRITE_SIZE
    • LEAVING_FUNCTION
    • LIBSSL_ERROR
    • LINE_TOO_LONG
    • LOADING_CONFIG
    • MISSING_KEY
    • MULTIPLE_ZERO_KEYS
    • PARSING_COMMAND
    • PARSING_CONFIG
    • PLAN_HASH_FAILED
    • PLAN_NOT_WELL_FORMED
    • PRIMARY_KEY_NOT_FOUND
    • PROCESSING_MESSAGE_TYPE
    • PSQL_STARTUP_PAIR
    • READ_MESSAGE
    • READ_TOO_LARGE
    • SEND_MESSAGE
    • SYSCALL
    • TABLE_DEFINITION_TOO_LONG
    • TABLE_NOT_FOUND
    • TYPE_MISMATCH
    • UNKNOWN_COLUMN_NAME
    • UNKNOWN_KEYWORD_STATE
    • UNKNOWN_MESSAGE_TYPE
    • UNKNOWN_TABLE
    • YOTTADB
  • Rocto Errors
    • INVALID_CHAR_VALUE
    • INVALID_INT_VALUE
    • INVALID_NUMBER
    • INVALID_TYPE
    • INVALID_VERSION
    • MISSING_DATA
    • MISSING_NULL
    • TOO_FEW_VALUES
    • TOO_MANY_VALUES
    • TRAILING_CHARS
  • PostgreSQL Error Codes Used
• Configuration
  • Config files
    • Logging
    • Locations and Global Variables
    • Environment Variables
  • Authentication