trying to read first 9 positions of a Char(50) datatype column

Question

I am trying to compare two columns one with Column1=Char(9) and other with Column2=Char(50). Need to do Column1=Column2, but I need only 1st 9 positions of column2 to be read to do the equality function. Please help.!! tried trim function as well

tried trim function as well. Please help with solution

Answer 1

In a Datastage Transformer substring functionality is done via

columnname[1,9] 

which means from position 1 cut 9 characters.