This content has been marked as final. Show 5 replies
lony wrote:Use OdiSqlUnload tool to write the output of the sql query to a file
I am using ODI 11g.
In ODI I want to write the output of the below query to a unix file.
SELECT 'H'|| rpad('SB9KT.KTPRTO.EBSDATA.D0000000','30',' ')|| rpad(to_char(sysdate, 'YYYYMMDDHHMMSS'), 16, ' ')
Please suggest any inputs.