I'm attempting to find "TacoBell" within a variable length record using the substring function. Unfortunately, I receive "ICE218A 6 1082 BYTE VARIABLE RECORD IS SHORTER THAN 9999 BYTE MINIMUM FOR FIELDS" error message upon execution. How do I specify to check the entire length of each record without actually specifying a value (9995)?
I've tried variations of the COND statement, but have yet to locate the answer. It has to be something simple that I'm overlooking!
As a side note, the value I wish to find can occur anywhere within the record.