Dear all
We have imported a stored procedure from SQL Server:
For BatchID IN parameter, there are both precision & length values:
What is the difference ?
Maybe it is not expected to have precision for string because I cannot see precision for usual string columns (not stored procedure).
Thanks in advance !
Jean-Pierre
The property fields for a column or parameter are a hold-over from the legacy Teiid Designer's EMF Ecore metamodel definition.
The precision property does not apply to the string datatype. For runtime datatype definitions see: https://docs.jboss.org/author/display/TEIID/Supported+Types
I created a new project with Teiid Designer 9.2, and have imported a stored procedure. The "Precision" field is still proposed for the procedure parameter.
From the documentation, could you clarify this point:
Does it mean length, precision, scale are for information only and are never used by Teiid for anthing ? I'd like just to understand if we have to take care of these attributes for our project.
Thanks for your help
String type only requires length attribute. Yes, as document says Teiid runtime does not enforce them right now, but they may get used in future releases.