Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using host variable with 'like' operator
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... -
Using host variable with 'like' operator
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... -
Using host variable with 'like' operator
Marc, I tried moving just NM% (without any quotes), and still it does not seem to work. Thanks, Jay. -
Using host variable with 'like' operator
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...
