Manually set the datatype attribute for a
ESP Schema definition if the
ESP Data Type column in the Attributes tab of an
ESP schema definition is empty or shows the wrong
values.
You may need to set datatypes for a logical data model you generate from a
physical data model, if the generation process cannot determine how to
convert the database datatype to an Event Stream Processor
datatype. Datatypes for the shipped sample model are set correctly and no
further adjustments are necessary.
- Right-click a schema definition and choose
Properties.
- Click the Attributes tab and review values in the ESP
Data Type column.
For example, in the sample model, the Bond Quote Attributes shows these datatypes:
| Attribute Name |
ESP Datatype |
|---|
| Instrument |
string |
| Quote Date |
date |
| Quote Sequence Number |
integer |
| Quote Time |
timestamp |
| Ask Price |
money(4) |
| Ask Size |
integer |
| Bid Price |
money(4) |
| Bid Size |
integer |
| Yield |
money(2) |
If values are missing or incorrect, continue with steps 3 -
5.
- Click Customize Columns and Filter
(Ctrl+U).
- If needed, adjust columns available for viewing:
- Unselect Data Type, Length, and Precision.
- Select:
- Name
- ESP
Datatype
- Length
- Precision
- Mandatory
- Primary Identifier
- Displayed (selected by default)
- Use the controls below the list to adjust the order so that Primary
Identifier and Displayed are the last two
checkboxes.
Performing this task once corrects the datatypes for all schema
definitions.