Working with records and tables

This section discuss creating new records, adding new fields to records, deleting records, modifying records, and viewing record details.

Creating a new record

Choose File>New>Record from the Records/Tables window menu.

The New Record window displays. There are two tabs pages: Required and Optional.
Enter the following information on the Required tab:
- Name – the name of the record.
- Description – a brief description of the record.
- Length – the actual length of the record if this is a fixed-length file or the maximum length of the record if it is a delimited file. If you do not know the length of the record, you can enter a zero (0), and ECMap calculates the length for you as you add fields to the record.
- End Character – Select the character used to indicate the end of the record from the drop-down list. Choices are:
  - CRLF
  - None
  - Null
  - SP CH (special character) Select an End Character from a drop-down list of characters that can be used as record delimiters. For example, to put a quote (“) as your end character, enter 034.
Enter the following information on the Optional tab:
- Record Type – select from the following choices on the drop-down list:
  - Source – the record is the input data to the map.
  - Destination – the record is the output data of the map.
  - Both – the record is both input data to and output data of the map.
    
    If you make no entry, the program uses Both as the default.
- Record Tag – only used when writing XML data. It is the name of the XML tag used to enclose the data, as shown below:
```
<RecordTagName>data</RecordTagName>
```
- Select Repeating if the record can repeat. (NDO files only.)
- Select Mandatory if the record is required. (NDO files only.)
Select OK.

The New Field window displays. There are two tabs on the New Field window – Fields and Options. On these two tabs, enter detailed information about the fields in the record. For more information see “Adding a new field to a record”.

Deleting a record

Select a record from the Records/Tables window and choose Record>Delete.

You are prompted to confirm the deletion.
Select Yes to delete the record.

Modifying a record

Select a record and choose Record>Properties.

The Record Properties window displays.
Make the necessary changes on the The Record Properties as described in “Creating a new record”.

Viewing record details

Select a record and choose View>Details from the View menu on the Records/Tables window.

The Details for Record window displays. On the window is a list of all the fields in the highlighted record with all of the attributes associated with each field.

Copying a record

Select a record on the Records/Tables window and choose Record>Template

The Template Record window displays.

The record-related information is identical to the source file. If you need to change the template copy, enter the information as described in “Creating a new record”.
Enter a name for the new record.
Select OK.