3. Tables

There are three kinds of tables and the icon beside the table name indicates which type it is. The table types and icons used are:

LANSA table

Created and maintained by LANSA.

IBM i Table

The definition of the table has been loaded into LANSA using Import Tables from an IBM i.

   

Imported Table   

Tables with this icon are created and maintained by another application. The definition of the table has been loaded into LANSA from an ODBC data source. They are not IBM i tables. For more information refer to Imported Tables in the Visual LANSA Developer's Guide.

 

3.1 Table Definition

3.2 Real Columns in Table

3.3 Virtual Columns in Table    

3.4 Indexes

3.5 Access Routes

3.6 Table Attributes

3.7 The @@UPID Column in LANSA Created Tables   

3.8 Batch Control

3.9 Virtual Derivation

3.10 Table Rules and Triggers

3.11 Table Compile Options

3.12 Import Tables from IBM i

3.13 Import Table Definitions

 

Also See

Editing Tables in the User Guide.

Developing Databases in the Developer Guide.