Manually set the datatype attribute for a RAP message definition if the RAP Dataype column in the Attributes tab of a RAP message 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 a RAP datatype. Datatypes for the shipped sample model are correct.
-
Right-click a message definition and choose Properties.
-
Click the Attributes tab and review values in the RAP Datatype column.
For example, in the sample model, the Bond Quote Attributes shows these datatypes:
| Attribute Name |
RAP Datatype |
| Instrument |
string |
| Quote Date |
date |
| Quote Sequence Number |
sint32 |
| Quote Time |
datetime |
| Ask Price |
decimal |
| Ask Size |
sint32 |
| Bid Price |
decimal |
| Bid Size |
sint32 |
| Yield |
decimal |
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:
-
Destination Column Name
-
RAP Dataype
-
Length
-
Precision
-
Lookup table name
-
Lookup column name
-
Lookup column return
-
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 datatypes for all message definitions.