Welcome to the Octo Documentation!
- Introduction
- Octo Upgrade Guide
- Octo 1.1 (Octo with AIM) Upgrade for Existing Octo VistA Users
- Introduction
- Upgrade YottaDB and Install Octo
- Stop VistA processes and
octo/rocto - Run down Databases and Relink Files
- Stop journaling and replication
- Adjust VistA environment to use the new version of YottaDB
- Add
ydb_env_setto your environment set-up - Recompile Object code (optional)
- Update the Octo VistA DDL
- Restart journaling and VistA processes
- DBMS Grammar
- Accepted Data Types
- Constraints
- CREATE TABLE
- CREATE FUNCTION
- CREATE VIEW
- DISCARD ALL
- DISCARD XREFS
- DROP TABLE
- DROP FUNCTION
- DROP VIEW
- TRUNCATE TABLE
- SELECT
- INSERT
- UPDATE
- DELETE
- SET
- SHOW
- Set Operations
- VALUES
- CASE
- Functions
- ABS
- COALESCE
- CONCAT
- CURRENT_CATALOG
- CURRENT_DATABASE
- CURRENT_ROLE
- CURRENT_SCHEMA
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- DAY
- DAYOFMONTH
- DATE_FORMAT
- GREATEST and LEAST
- HAS_DATABASE_PRIVILEGE
- LOCALTIME
- LOCALTIMESTAMP
- LPAD
- NOW
- NULLIF
- PG_ENCODING_TO_CHAR
- PG_IS_IN_RECOVERY
- PG_IS_XLOG_REPLAY_PAUSED
- REPLACE
- ROUND
- SESSION_USER
- TRUNC/TRUNCATE
- USER
- Aggregate Functions
- Constructors
- Operators
- Alias
- Pattern Processing
- Useful Commands at OCTO>
- Technical Notes
- Advanced Mapping of YottaDB Globals to Octo Tables
- SQL NULL Values
- Administration
- ROcto
- Error Messages
- Error Message Severities
- Octo or ROcto Errors
- ERR_AGGREGATE_FUNCTION_CHECK
- ERR_AGGREGATE_FUNCTION_JOIN
- ERR_AGGREGATE_FUNCTION_NESTED
- ERR_AGGREGATE_FUNCTION_UPDATE
- ERR_AGGREGATE_FUNCTION_WHERE
- ERR_AMBIGUOUS_COLUMN_NAME
- ERR_AS_MORE_COLUMNS
- ERR_AUTO_UPGRADE
- ERR_AUTO_UPGRADE_DB_HIGHER_FMT
- ERR_BAD_CONFIG
- ERR_BAD_ZROUTINES
- ERR_BUFFER_TOO_SMALL
- INFO_CALLING_M_ROUTINE
- ERR_CANNOT_CREATE_FUNCTION
- ERR_CANNOT_CREATE_TABLE
- ERR_CANNOT_CREATE_VIEW
- ERR_CANNOT_DROP_FUNCTION
- ERR_CANNOT_DROP_TABLE
- ERR_CANNOT_DROP_VIEW
- ERR_CASE_BRANCH_TYPE_MISMATCH
- ERR_CASE_VALUE_TYPE_MISMATCH
- ERR_FORMAT_NOT_ALLOWED_WITH_CAST
- ERR_CHECK_CONSTRAINT_VIOLATION
- ERR_CIRCULAR_EXTRACT_DEFINITION
- INFO_CLIENT_CONNECTED
- ERR_COMMON_COLUMN
- ERR_CONFIG_IO_FAILURE
- INFO_CURPLAN
- INFO_CURSOR
- ERR_DATABASE_FILES_OOS
- ERR_DATE_TIME_RESULT_OUT_OF_RANGE
- ERR_DDL_LITERAL
- ERR_DOLLAR_SYNTAX
- ERR_DROP_FUNCTION_DEPENDS
- ERR_DROP_FUNCTION_DEPENDS_ON_VIEW
- ERR_DROP_TABLE_DEPENDS_ON_VIEW
- ERR_DROP_VIEW_DEPENDS_ON_VIEW
- ERR_DUPLICATE_COLUMN
- ERR_DUPLICATE_CONSTRAINT
- ERR_DUPLICATE_KEY_VALUE
- ERR_DUPLICATE_PRIMARY_KEY_CONSTRAINT
- INFO_ENTERING_FUNCTION
- INFO_ENV_VAR
- INFO_EXECUTION_DONE
- ERR_EXTRACT_CANNOT_BE_KEY_COLUMN
- ERR_EXTRACT_TYPE_MISMATCH
- ERR_FAILED_TO_OPTIMIZE_PLAN
- ERR_FAILED_TO_PARSE_SCHEMA
- ERR_FAILED_TO_RETRIEVE_ENVIRONMENT_VARIABLE
- ERR_FEATURE_NOT_IMPLEMENTED
- ERR_FILE_NOT_FOUND
- ERR_FUNCTION_NOT_UNIQUE
- INFO_FUNCTION_ALREADY_EXISTS
- INFO_FUNCTION_DOES_NOT_EXIST
- INFO_FUNCTION_SEARCH
- ERR_GENERATING_TEMPORARY_TABLE
- INFO_GENERATING_XREF
- ERR_GLOBAL_KEY_COLS_ORDER
- ERR_GLOBAL_MISSING_KEY_COLS
- ERR_GROUP_BY_INVALID_USAGE
- ERR_GROUP_BY_OR_AGGREGATE_FUNCTION
- ERR_GROUP_BY_POSITION_INVALID
- ERR_GROUP_BY_POSITION_NOT_INTEGER
- ERR_GROUP_BY_SUB_QUERY
- ERR_KEYS_NEEDS_A_KEY_COLUMN
- ERR_IDENT_LENGTH
- ERR_INIT_SCANNER
- ERR_INSERT_ON_GENERATED_ALWAYS_IDENTITY
- ERR_INSERT_TOO_MANY_COLUMNS
- ERR_INSERT_TOO_MANY_EXPRESSIONS
- ERR_INSERT_TYPE_MISMATCH
- ERR_INVALID_BOOLEAN_SYNTAX
- ERR_INVALID_CLI_OPTION
- ERR_INVALID_CONSTRAINT_EXPRESSION
- ERR_INVALID_DATE_TIME_VALUE
- ERR_INVALID_DATE_TIME_TYPE_FORMAT
- ERR_INVALID_DATESTYLE_VALUE
- ERR_INVALID_DROP
- ERR_INVALID_ESCAPE_PATTERN
- ERR_INVALID_INPUT_SYNTAX
- ERR_INVALID_INTEGER_SYNTAX
- ERR_INVALID_NUMERIC_SYNTAX
- ERR_INVALID_KEYWORD_CHAR
- ERR_INVALID_NUMBER
- ERR_PARSE_FAILED
- ERR_INVALID_READ_SIZE
- ERR_INVALID_RUNTIME_PARAMETER
- ERR_INVALID_TYPE
- ERR_INVALID_WRITE_SIZE
- ERR_JOIN_ALIAS_DUPLICATE
- INFO_LEAVING_FUNCTION
- ERR_LIBCALL
- ERR_LIBCALL_WITH_ARG
- ERR_LIBSSL_ERROR
- ERR_LINE_TOO_LONG
- ERR_LITERAL_MAX_LEN
- INFO_LOADED_CONFIG
- INFO_M_PLAN
- INFO_MEM_REALLOCATION
- ERR_MEMORY_USAGE
- INFO_MEMORY_USAGE
- ERR_MIDENT_LENGTH
- ERR_MISSING_FROM_ENTRY
- ERR_MISSING_KEY
- ERR_MISTYPED_FUNCTION
- ERR_MISTYPED_FUNCTION_TABLE_ASTERISK
- ERR_MULTIPLE_VALUES_PROVIDED
- ERR_MULTIPLE_ZERO_KEYS
- ERR_NEGATIVE_SUBSTRING_LENGTH
- ERR_NOT_OPERATION_TYPE_MISMATCH
- ERR_NON_INTEGER_IDENTITY
- ERR_NULL_COL_VALUE
- ERR_NULL_SUBS_DISABLED
- ERR_NUMERIC_SCALE
- ERR_NUMERIC_OVERFLOW
- ERR_AUTO_SEED_LOAD
- ERR_ORDER_BY_POSITION_INVALID
- ERR_ORDER_BY_POSITION_NOT_INTEGER
- ERR_ORDER_BY_SELECT_DISTINCT
- INFO_OCTO_STARTED
- ERR_PARM_CANNOT_BE_CHANGED
- ERR_PARSING_COMMAND
- ERR_PARSING_CONFIG
- INFO_PARSING_DONE
- ERR_PERCENT_IN_EXTRINSIC_FUNCTION_NAME
- ERR_PLAN_HASH_FAILED
- ERR_PLAN_NOT_GENERATED
- ERR_PLAN_NOT_WELL_FORMED
- ERR_PLAN_OWNER
- ERR_PRIMARY_KEY_NOT_FOUND
- INFO_PROCESSING_MESSAGE_TYPE
- WARN_FEATURE_NOT_IMPLEMENTED
- WARN_READLINE_LOAD_FAIL
- WARN_READLINE_SAVE_FAIL
- INFO_READLINE_NOTIFY_HIST_COUNT
- INFO_READLINE_NOTIFY_HIST_STIFLED
- INFO_READLINE_NOTIFY_HIST_LOCATION
- INFO_READLINE_NOTIFY_LOAD
- INFO_READLINE_NOTIFY_LOAD_COUNT
- INFO_READLINE_NOTIFY_SAVE
- INFO_READLINE_NOTIFY_SAVE_COUNT
- ERR_READONLY_DISALLOWED
- ERR_READONLY_AND_READWRITE_DISALLOWED
- ERR_READWRITE_DISALLOWED
- INFO_READ_MESSAGE
- INFO_RECORDING_ENV_VARS
- INFO_RETURNING_FAILURE
- INFO_REUSE_M_PLAN
- SELECT_STAR_NO_TABLES
- INFO_SEND_MESSAGE
- ERR_SETOPER_NUMCOLS_MISMATCH
- ERR_SETOPER_TYPE_MISMATCH
- ERR_SUBQUERY_ONE_COLUMN
- ERR_SUBQUERY_CHECK
- ERR_SUBQUERY_MULTIPLE_ROWS
- ERR_SYSCALL
- ERR_SYSCALL_WITH_ARG
- INFO_TABLE_ALREADY_EXISTS
- ERR_TABLE_ASTERISK_COLUMN_COUNT_MISMATCH
- ERR_TABLE_ASTERISK_COLUMN_TYPE_MISMATCH
- ERR_TABLE_ASTERISK_SCALAR_COMPARISON
- ERR_TABLE_DEFINITION_TOO_LONG
- INFO_TABLE_DOES_NOT_EXIST
- INFO_VIEW_DOES_NOT_EXIST
- ERR_TABLE_KEY_NUM
- ERR_TABLE_MULTIPLE_IDENTITY
- ERR_TABLE_MULTIPLE_PRIMARY_KEYS
- ERR_TABLE_MUST_HAVE_A_VISIBLE_COLUMN
- ERR_TABLE_MUST_HAVE_A_NON_EXTRACT_COLUMN
- ERR_TABLE_READONLY
- INFO_TABLE_OR_VIEW_SEARCH
- ERR_TABLE_UNKNOWN_COLUMN_NAME
- INFO_TEXT_REPRESENTATION
- ERR_TOO_MANY_DELIM_CHARS
- ERR_TOO_MANY_FUNCTION_ARGUMENTS
- ERR_TOO_MANY_SELECT_KEYCOLS
- ERR_TOO_MANY_TABLE_KEYCOLS
- ERR_TYPE_CAST
- ERR_TYPE_MISMATCH
- ERR_TYPE_NOT_COMPATIBLE
- ERR_UNGROUPED_OUTER_QUERY_COLUMN
- ERR_UNKNOWN_COLUMN_NAME
- ERR_UNKNOWN_FUNCTION
- ERR_UNKNOWN_FUNCTION_EMULATION
- ERR_UNKNOWN_KEYWORD_STATE
- ERR_UNKNOWN_MESSAGE_TYPE
- ERR_UNKNOWN_TABLE
- ERR_UNKNOWN_TABLE_OR_VIEW
- ERR_UPDATE_OF_GENERATED_ALWAYS_IDENTITY
- ERR_VALUES_LENGTH
- ERR_VALUES_NEEDS_A_NON_KEY_COLUMN
- ERR_VALUES_NOT_ALLOWED_IN_GLOBAL
- ERR_VALUES_NOT_ALLOWED_IN_START_END
- ERR_VARCHAR_TOO_LONG
- ERR_VIEW_MORE_COLUMN_NAMES
- ERR_VIEW_OPERATION_NOT_SUPPORTED
- ERR_WRONG_TYPE
- ERR_YOTTADB
- ERR_ZERO_LENGTH_IDENT
- Rocto Specific Errors
- INFO_AUTH_SUCCESS
- ERR_ROCTO_BAD_ADDRESS
- ERR_ROCTO_BAD_PASSWORD
- ERR_ROCTO_BAD_TIMESTAMP
- ERR_ROCTO_BIND_PARAMETER_DECODE_FAILURE
- ERR_ROCTO_BIND_TO_UNKNOWN_QUERY
- INFO_ROCTO_CHILD_STATE_UPDATED
- INFO_ROCTO_CLEAN_DISCONNECT
- ERR_ROCTO_COLUMN_VALUE
- ERR_ROCTO_COMMAND_TAG
- ERR_ROCTO_DB_LOOKUP
- ERR_ROCTO_HASH_CONVERSION
- ERR_ROCTO_INVALID_INT_VALUE
- ERR_ROCTO_INVALID_ITEM_VALUE
- ERR_ROCTO_INVALID_MESSAGE_TYPE
- ERR_ROCTO_INVALID_NUMBER_BIND_PARAMETERS
- ERR_ROCTO_INVALID_NUMBER_COLUMN_FORMAT_CODES
- ERR_ROCTO_INVALID_FORMAT_CODE
- ERR_ROCTO_INVALID_VERSION
- ERR_ROCTO_MISSING_DATA
- ERR_ROCTO_MISSING_NULL
- ERR_ROCTO_MISSING_USERNAME
- ERR_ROCTO_NONEXISTENT_KEY
- ERR_ROCTO_NO_SCHEMA
- ERR_ROCTO_NOSCHEMA_USER
- ERR_ROCTO_PARAMETER_COUNT
- ERR_ROCTO_PASSWORD_TYPE
- ERR_ROCTO_PERMISSIONS_LOOKUP_FAILED
- ERR_ROCTO_QUERY_CANCELED
- ERR_ROCTO_QUERY_TOO_LONG
- ERR_ROCTO_READ_FAILED
- ERR_ROCTO_READONLY_MODE
- ERR_ROCTO_READONLY_USER
- ERR_ROCTO_READ_TOO_LARGE
- INFO_ROCTO_PARAMETER_DESCRIPTION_SENT
- INFO_ROCTO_PARAMETER_STATUS_SENT
- INFO_ROCTO_ROW_DESCRIPTION_SENT
- INFO_ROCTO_SERVER_FORKED
- INFO_ROCTO_STARTED
- ERR_ROCTO_SECRET_KEY_MISMATCH
- ERR_ROCTO_SEND_FAILED
- ERR_ROCTO_SESSION_LOOKUP
- ERR_ROCTO_TLS_ACCEPT
- ERR_ROCTO_TLS_CONNECTION
- ERR_ROCTO_TLS_INIT
- ERR_ROCTO_TLS_READ_FAILED
- ERR_ROCTO_TLS_REQUIRED
- ERR_ROCTO_TLS_SOCKET
- ERR_ROCTO_TLS_UNKNOWN
- ERR_ROCTO_TLS_UNNAMED
- ERR_ROCTO_TLS_WANT_READ
- ERR_ROCTO_TLS_WANT_WRITE
- ERR_ROCTO_TLS_WRITE_FAILED
- ERR_ROCTO_TOO_FEW_VALUES
- ERR_ROCTO_TOO_MANY_VALUES
- ERR_ROCTO_TRAILING_CHARS
- ERR_ROCTO_UNSUPPORTED_BIND_PARAMETER
- ERR_ROCTO_USER_LOOKUP
- ERR_NO_TRANSACTION_IN_PROGRESS
- ERR_TRANSACTION_IN_PROGRESS
- ERR_TRANSACTION_NO_UPDATES
- PostgreSQL Error Codes Used
- Configuration
- History
- Pitfalls
- Developer Documentation
- LICENSE
