I am developing a job.
sequential file is my source stage and teradata table is destination.
in source file two columns (D_TIME,SNO) are there. In table as well.
i want to update data in the table when the SNO Matches with using sql staement only.(Not by using Transformer or any other stage)
(update T_NAME set D_TIME=sequential_file_1.d_time where sno=1)
i am trying this query but it is not working..
can anyone please suggest the exact statement.
i am new to datastage.
thanks in advance
Pinned topic datastage teradata connector stage
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-04-04T06:54:34Z at 2013-04-04T06:54:34Z by SystemAdmin
SystemAdmin 110000D4XK7754 Posts
Re: datastage teradata connector stage2013-04-04T06:54:34ZThis is the accepted answer. This is the accepted answer.If you are loading from sequential file to direct table then better you go for update table action. no need to write explicit query. I am considering that in seq file you have records those already exist...if thats not a case then better go for update then insert option.
hope this will help!