Réponse
In the 'cntl' parameter, you can set 'optimizeVarcharPrecision' or 'optimizeVarbinaryPrecision' to TRUE. This optimizes the precision to be appropriate for the actual data instead of using the declared precision.
Did this answer help you?
execDirect
fedSql
Other questions about execDirect
How can I ensure that a query only runs if full implicit pass-through is achieved?
Lire la réponse
What is the default behavior for implicit pass-through in the execDirect action?
Lire la réponse
Which parameter is mandatory when using the execDirect action?
Lire la réponse
Is it possible to force a specific join order for tables?
Lire la réponse
How can I get details about query execution stages?
Lire la réponse