Question
I tried to refer to the component variable "count" of Execute Select SQL with Mapper, but it becomes null instead of the actual number of items.
Please tell me how to solve this problem.
Answer
When Parallel Streaming Processing (PSP) is used, the component variable "count" of Execute Select SQL does not store a value and the default value "null" remains.
This specification is described in the following manual under [count] - [Remarks].
Execute Select SQL
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/database_execute_select_SQL.htm
-Workaround
By deactivating PSP, the data count can be stored as expected.
Comments
0 comments
Article is closed for comments.