Using EARL to select records from the TMC and build TMSUPDTE control statements. Would like the VERify on the DSN but the DSN has special characters so I have to use a delimiter before and after the DSN. Normally use a single quote mark for this. I have not been able to define a field and give it a value of a single quote and I am not allowed to SET the field in the output to a single quote.
TMSUPDTE will accept other characters as a delimiter. Since a DSN cannot contain a * I have him use the * as the delimiter.
SET fieldname = '*'