Need to create a file with with a single quote mark in a given column

Document ID : KB000076491
Last Modified Date : 04/04/2018
Show Technical Document Details
Issue:
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.
Resolution:
TMSUPDTE will accept other characters as a delimiter.  Since a DSN cannot contain a * I have him use the * as the delimiter.  
SET fieldname = '*'