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.