According to the documentation, the derivation
Code: Select all
IsValid('date [%yyyy%ddd]',In.Col)
I've played with variations on this theme with no luck, and have searched both the DataStage PDFs as well as the orchestrate documentation to no avail.APT_CombinedOperatorController,0: The schema type "date" does not take parameters "%yyyy%ddd"
IsValid('date ["%yyyy%ddd"]',In.Col)
IsValid('date "[%yyyy%ddd]"',In.Col)
IsValid('date %yyyy%ddd',In.Col)
IsValid('date "%yyyy%ddd"',In.Col)