is there an option to modify the maximal string size that can be selected with embedded SQL Select?
At the moment there is a limit of about 32000.
This is my workaround at the moment (dw_syntax can be larger than 32k):
selectblob dwsyntax into :lb_dwsyntax from sp....() using sqlca; ls_dwsyntax = string(lb_dwsyntax,EncodingAnsi!)This dont't work with more that 32k size, but would be the better solution:
select dwsyntax into :ls_dwsyntaxfrom sp....() using sqlca;