I am trying to write a procedure to decode a message, but I'm running into a problem when I'm doing substring based on variable holding the start position or variable holding the length. I'm doing the following:
CREATE PROCEDURE (code VARCHAR(100))
DEFINE xi INTEGER;
DEFINE tag CHAR(4);
LET xi = 1;
LET tag = ex_emv_params[xi,4];
When I run it I get a syntax error (-201) on the LET tag = ex_emv_params[xi,4]; line (where xi is present). If I change the xi to 1 it works....
Anyone knows work around?