DSXchange

Is the column what used for the constraint is it an integers (for example: 1, 2, ----, 11, 12) or it is a date column? If the column being reference in the constraint is integer the suggestion provided above should be followed. If the column being reference is a date then use the code below to fetch...

Try the basic solutions listed below first.

1. Close and open the pallete.
2. Close the DS Designer and open it.
3. Restart the 3 DS services "Datastage Engine Resource Service", "Datastage Telnet Service", "DSRPC Service"

If you want to execute the substring operation through transformer then below is an example what you can refer. Input1 - column name expression in the transformer stage expression editor. Input1[1,3] note: 1 is the starting position and 3 is the string length. if your Input1 data is "SUBSTRING&...