Issue :
We design a Datastage job using the Unstructured stage to read data only from this sheet.
Sales - Data!A1:D50
The stage gives an invalid character error and does not accept the sheet name.
Solution :
Give the sheet name within single quotes. Datastage - Unstructured stage presumably treats the hyphen as a minus and hence we need to escape this special character using single quotes.
'Sales - Data'!A1:D50
Tags
Datastage