I'm trying to map an existing global using CacheSQLStorage and only return rows that have a number that is a multiple of 100 in subscript 3. I'm guessing that I need to use nextcode in my CDL to start at 100 and increment the value of the field/subscript by 100. Like this:
subscript 3 {
nextcode = {
S {S3}={S3}+100
}
startvalue=100;
}
However, I get the error: #524: Invalid {Field} reference.
Any suggestions? I'm using Cache' 4.1.9.
