User guide

The view model editor
60 Data Integration with Sybase Avaki Studio
Red borders: Errors in your view model
Your view model may have errors in it. Some of these may be because certain ele-
ments are not properly configured or connected. If Studio detects an error, it notifies
you by making the border around the affected elements red. You can see what the
problem is by moving your cursor over the element in question—Studio displays the
error message in a tool tip. You must resolve all of these errors before you can execute
or deploy the view model. (Note that if an operator with an error is not actually con-
nected to the Result element in any way, then you may still be able to execute and
deploy the model even if it shows an error.)
Working with schemas
Many of the operators in Avaki Studio allow you to define or transform the schema of
the data passing through them. The visual representation of each element in the view
model can optionally display the schema of your data at that point in the flow.
Showing and hiding elements’ schemas
Every element in your Avaki view model, from the input sources to the result, has a
schema associated with it. Objects are created initially with the schema showing, but
you may wish to hide them to make your model easier to read. You can show or hide
the list of column names for any given element by clicking the triangle next to the
“Schema” label.
Specifying schemas for operators
A schema is defined as an ordered list of columns where each column has the proper-
ties name, type, precision, and scale:
Name. Since they are used within expressions to access their data, names for columns
must meet the same constraints as other variables: they must start with a letter or
underscore, and must contain only letters, numbers, and underscore characters. Other