search cancel

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


Article ID: 76491


Updated On:


CA 1 Tape Management CA 1 Tape Management - Copycat Utility CA 1 Tape Management - Add-On Options Earl


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.


Release: ONE...00200-12.6-One-TAPE MANAGEMENT


TMSUPDTE will accept other characters as a delimiter.  Since a DSN cannot contain a * I have him use the * as the delimiter.  
SET fieldname = '*'