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

Article Id: 76491

Status: Published

Updated On: 04-04-2018 11:57

Products:

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

Issue/Introduction:

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.

Environment:

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

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