Table Tab

How To Access

  • Main Menu | Maintenance | Create Table

Allows you to select database settings, enter the table’s root, logical, and display names, and determine whether connection information is stored in the INT file.

  • Root Name: The physical name of the file.

  • Logical Name: The name as it appears in a DataFlex program.

  • Display Name: A user-friendly description as it appears in the filelist.

  • Database Name: The database on the server where this table resides. Select the name of the database from the pulldown list when creating a new table. You cannot select database storage and schema options if you are restructuring a table. You can only select these options if you are creating a new table.

  • Data Tablespace: The tablespace where data resides. Select the name of the tablespace from the pulldown list when creating a new table.

  • Index Tablespace: The tablespace where indexes reside. Select the name of the tablespace from the pulldown list when creating a new table.

  • Schema name: The table owner.

  • OEM to ANSI: Select this option to convert the OEM character set (used by DataFlex) to the ANSI character set. See Also: OEM Support

  • System File: Select to specify this file is a system file, a DataFlex file containing only one record.

  • Cache Mode: Select to enable local data caching. The specified number of records (Max Rows) is held in local cache for fetching.

  • Set Mode: The number of records selected for Max Rows (default is 10) is fetched in one network round-trip. Use the spin button to set the number.

  • Login defaults: Select an option to store the indicated information in the .INT file. If an option is not selected, the information must be provided in a connection string. For example if Put Server Name into INT file is not checked, the server name must be included in the connection string.