What is precision for string procedure parameter ?

[jpmat]

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

[blafond]

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

[jpmat]

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

[rareddy]

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.