Table of contents

Official Content

Defines all the information related to an external table to access it like any other table created by GeneXus.

As you all know, upon defining Transaction objects, tables are created in the database that is associated with an Environment. In some cases, you may need to work with existing tables that are not included in our data model, and which are called "external tables." They may belong to another model or version, or they may not be created by GeneXus.

Even though GeneXus cannot reorganize these tables, it can query them and make additions, deletions, and changes.

There are two ways to work with an external table: with an associated Transaction to make additions, deletions, and changes to this table, or without an associated Transaction. In this case, these operations can only be made through Procedure objects, and not with the usual commands but with others. The most common reasons for which Data Views are defined without an associated Transaction are when it's necessary to access an external table that has no indexes, or when it's necessary to access external tables, only once, just to define load processes (that is, batch processes that run through external tables and load tables of the Environment). Clearly, in these cases, it's not necessary to have interactive access to the external tables, but only through batch load processes; and lastly, another reason to do so is when you don't need this file to participate in the data model normalization.


Data Views do not necessarily handle a table that belongs to a database; even though it happens most of the time, it can also be a text file or another type of file.

Subcribe to this category's changes
Sub CategoriesAdd a new subcategory in this category
PagesAdd a new page in this category
Last update: November 2023 | © GeneXus. All rights reserved. GeneXus Powered by Globant