Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

How To: Use UDF Transformations


Overview

The Jet Data Manager has changed the way it handles transformations. The code generator will now use use Set Based Transformations instead of Scalar-Valued User Defined Functions. This should have a huge increase in performance.

As changing how we generate transformations in SQL is a major change, we have decided to include a way to turn this new functionality off if it  - against our best intentions and testing should generate wrong code in some scenarios. The follow demonstrates how to enable Scalar-Valued User Defined Functions.

Process

1. Right click on a table and select Advanced → Advanced Settings .

2. Check the box to enable UDF Transformations.

  • If Use UDF Transformations is checked, the Jet Data Manager will revert to the previous SQL Code generation for transformations and create Scalar-Valued User Defined Functions.
  • If Use UDF Transformations is un-checked (Default), then the Jet Data Manager will generate CASE-WHEN structures in the Transformation views instead of Scalar-Valued User Defined Functions.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments