|
Create Table in External
Database option allows you to create a table in the external database of
your choice that will contain the fields from the Field Extractor.
To create a table, select
Field Extractor -> Create Table in
External Database.
Create Table window
will be displayed. You need to perform 4 steps to create your table:
1. Create Field(s).
This window shows the fields that you set up in the Field
Extractor. To change the Field Type,
click the mouse on the appropriate cell, then click the down arrow and select
the data type from the drop down menu. This way you can also set a single-field
index in the Indexed column.
The Indexed property uses the following settings.
Primary Index -
The Indexed property
for that field to Yes (No Duplicates) will be automatically set.
Yes (Duplicates OK) -
The index allows duplicates.
Yes (No Duplicates) -
The index doesn't allow duplicates.
No - (Default) No index.
ATTENTION!
|
|
If a field name appears marked by
red, it means that you use the program's reserved fields. Reserved
keywords are part of the grammar of the Transact-SQL language used by G-Lock
Email Processor.
If you are going to set up Database Manager, you should
change red field names in order to avoid errors. You can use lowercase and
uppercase letters, numbers from 0 to 9 and the underline _ symbol, for
example:
Date -> DateM
From -> From1
To -> To_ |
To insert a new field, click Insert.
To delete a selected field, click Delete.
To move a selected field up, click Move Up.
To move a selected field down, click Move
Down.
Click Step 2.
2. Select Database.
Click Select Database
button to specify the database where you want to create your table.
Enter the name of your table in
Table Name box.
Click Step 3.
3. Create Table.
Here you can see the SQL Statement generated from the Field
Extractor fields.
Check if it is correct and click
Create Table button.
4. Create Index(es).
Here you can see the indexes you created for your fields. You
can make the adjustments manually if needed.
Click Create Index.
|
