DSXchange

HI use this select statement u can get as u required select max(code1) || max(var1) ||min(code1)||min(var1),group1 from abc group by group1 Thanks Dharma Hi , Please help me how to implement this logic in DS. soure is coming like this code1 val1 group1 ____________________________________ 1 p abc 0 ...

Hi, Check out this select to_char(to_date(101,'j'),'jsp') from dual; it gives you one hundred one good luck Dharma Hi All, My source file is a flat file.In that,i have a column with numeric datatype. i want to convert number into word. for example Input,Output 100,ONE HUNDRED 101,ONE HUNDERD ONE 123...

Hi

oconv(iconv(input_col,'D-YMD[4,2,2]),'D-YMD[2,A3,4]')

Dharma.

raji wrote:Hi all,

I have to convert the date format "yyyy-mm-dd" to "dd-mon-yyyy"

where my job looks like


SEQ.FILE----- TRANSFORMER STAGE----- SEQ.FILE

Please anybody help me out.

Thanks in advance