I've set the stage up as a "Transform" type, and I'm using the following syntax to call the procedure:
Code: Select all
CALL D1K.SPKF100_XRF_TYPE(?, ?, ?, ?, ?, ?, ?, ?, ?);
Code: Select all
APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003
So, my question is:
How can I input a value to, or specify a value within, the stored procedure stage that is exactly 31 bits long? I have tried doing this using a Row Generator stage, but have received the same error as above. For reference, the visible Row Generator output was "{00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00}", which does not work if typed directly into the Parameters tab of the stored procedure stage. I've also tried various expessions such as "0", "\0", and "0x0000000000000000000000000000000" to no avail.
Any help will be appreciated.