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
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 = '*'