Thanks one and all,
I tried various options you suggested, and the one wherein we replace the remaining bytes with '_' or '%' worked well.
The solution having to define a variable length variable - didn't seem to work. Or I might have missed sth here.
Anyway, I am glad that I joined this tek...
Yes, I do have rows with COLUMN1 beginning with caps NM. I didn't try in spufi, however I tried the same in the embedded SQL in the cobol program itself. It does work with literal '%NM%' in the cursor definition. It does not work with a host variable. Sometimes so called obvious things cause...
Hi, I have some problems using the host variable with like operator. I have a situation wherein I have to extract rows with a particular column matching different patterns. e.g
SELECT *
FROM MYTABLE
WHERE COLUMN1 LIKE :PATTERN;
I am embedding the above SQL in my COBOL code as part of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.