execDirect - How can I optimize precision for VARCHAR or VARBINARY data types?

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

Doc : execDirect
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
What options are available to view the FedSQL query plan?
Lire la réponse
What does the 'dynamicCardinality' control parameter do?
Lire la réponse
Copyright © WeAreCAS 2014-2026
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.