invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERSETTINGS: In-Memory

insert update delete

  • Catalog: ``
  • Primary Keys: rowid$

Can retrieve data and change data using insert, update and delete.

Performance Characteristics

Characteristic Value
Estimated rows 1
Estimated size (bytes) 6,172

Table Columns

The columns of the table PROVIDERSETTINGS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ABBREVIATION varchar2(30) Abbreviation Abbreviation.
CLOUD_URL varchar2 Cloud URL fetched only when named
COMMERCIAL_NAME varchar2 Commercial Nalangme fetched only when named
COMMERCIAL_NAME_DD_HMXP varchar2 commercial_name_dd_hmxp
COMMUNITY_EDITION char Is Community Edition Is application software offered for free?
DESCRIPTION_HMXP varchar2 description_hmxp
DESCRIPTION_MD varchar2 description_md
DISPLAY_NAME_HMXP varchar2 display_name_hmxp
DISPLAY_NAME_MD varchar2 display_name_md
DOCUMENTATION varchar2(32767) Documentation Documentation.
DOCUMENTATION_URL varchar2(4000) Documentation (URL) Documentation URL.
DOWNLOAD_IMPLEMENTATION_URL varchar2(4000) Download Implementation URL Download URL for implementation.
FORUM_TAG varchar2 Forum Tag fetched only when named
FUNCTIONAL_DOCUMENTATION_URL varchar2(4000) Functional Documentation URL Functional documentation URL.
FUNCTIONAL_SUPPORT_DISCORD_COMMUNITY varchar2(60) Functional Support Discord Community Functional support discourse community.
FUNCTIONAL_SUPPORT_EMAIL_ADDRESS varchar2(60) Functional Support Email Address Functional support email address.
FUNCTIONAL_SUPPORT_PHONE_NUMBER varchar2(60) Functional Support Phone Number Functional support phone number.
FUNCTIONAL_SUPPORT_URL varchar2(240) Functional Support URL Functional support URL.
IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME char Is Catalog Used in Full Qualified Name Whether the catalog name is used in constructing the full qualified name.
IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME char Is Schema Used in Full Qualified Name Whether the schema name is used in constructing the full qualified name.
IS_SERVICE_PROVIDER_FLAG char Is Service Provider? Is the connector a service connector?
LANGUAGE_CODE_HMXP varchar2 fetched only when named
LANGUAGE_CODE_MD varchar2
MAIN_CATEGORY varchar2(240) Main Category Main category.
NAME varchar2 fetched only when named
PARTITION_CODE_COLUMN_NAME varchar2(240) Partition Code Column Name Name of the partition code column.
PARTITION_INFO_SUPPORTS_PARTITIONS char Supports Partitions Whether the connector supports partitions.
PARTITION_LABEL_SINGULAR varchar2(240) Partition Label Singular Partition label in singular form.
PRODUCTION_USE_ALLOWED char Production Use Allowed Is production use allowed?
PROVIDER_FILE_NAME_PREFIX_HMXP varchar2 provider_file_name_prefix_hmxp
PROVIDER_FILE_NAME_PREFIX_MD varchar2 provider_file_name_prefix_md
PUBLIC_DATA char Is Public Data? Is the data offered publicly?
RUN_ID guid run_id
SHORT_NAME varchar2(240) Short Name Short name.
STRING_COMPARISON_IS_CASE_SENSITIVE char String Comparison is Case-Sensitive Whether the connector matches text case-sensitive.
TECHNICAL_DOCUMENTATION_URL varchar2(4000) Technical Documentation (URL) Technical documentation URL.
TECHNICAL_SUPPORT_DISCORD_COMMUNITY varchar2(60) Technical Support Discord Community Technical support discourse community.
TECHNICAL_SUPPORT_EMAIL_ADDRESS varchar2(60) Technical Support Email Address Technical support email address.
TECHNICAL_SUPPORT_PHONE_NUMBER varchar2(60) Technical Support Phone Number Technical support phone number.
TECHNICAL_SUPPORT_URL varchar2(240) Technical Support URL Technical support URL.
rowid$ number Row ID computed Artificial primary key of an in-memory table.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: