on 11-19-2019 8:58 PM
I am using PD 16.6.0.0.(4971).
When I create a function with parameters and set default values for these "IN" parameters, for some reason the function is generated without those defaults. Also, I’ve noticed that the PDM I imported from an earlier version is now missing these defaults. It is possible I am doing something wrong so my apologies beforehand but in case there is a bug I’d like to know about it. I figured out workaround to create a new "function" template without any %name% and other placeholders and hand-code the definition with hardcoded defaults. But that should not be the preferred solution.
Below is a snapshot of the PD environment.
The following settings will not appear in the generated "procedures" file.
Ok, thank you for the KBA reference.
Here is my workaround in case others will run into the same issue as well. It may not be perfect but it works.
1) add new custom function/procedure template (Database -> Edit Current DBMS) and strip all %QUALIFIER% and other variables away from the new template.
2) create new function from this bare-bones template and provide full function definition (including the parameters and their defaults)
3) save and generate new procedure file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.