Community
Participate
Working Groups
In the DTP SQL Query Builder, an user can manually input a named parameter variable, and even use duplicated parameter variable names. Thus the ODA runtime driver should be able to handle them by mapping named parameters to the corresponding parameter position. At runtime, the named parameter variables in a prepared SQL text will be replaced by '?' parameter marker(s). The custom ODA data set wizard page should be enhanced to process named parameter variables if any, plus obtain the parameter metadata available in the SQL Query model for its data set parameter design.
Resolved. Also updated the mapping of native data type codes supported by SQB.