DSXchange

Thanks kwwilliams,I got you.

update dw1.ethan_ssa_sr set sde_dtrd=? where dtke_dkg_id =? and exists (select 1 from dw1.ethan_ssa_sr a where a.dtke_dkg_id =dtke_dkg_id )
if changed to this one ,what do you think kwwilliams?

Here is the detail error logs:

[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000

Hi all, I want to update the target table ,But maybe the data in target table not exists . in the job i Want not to use the join or lookup and so on. so before I update the data I need to judge if there is exists data which i want to update. I write like this : update dw1.ethan_ssa_sr set sde_dtrd=?...

Hi vinodkumards
I come from bj,but i don't think you should used filter stage,what you means different Clause to different flows ?

Hi

I a newcomer of the datastage ,Who can help to tell The difference between run and reset if request then run.

Hi All ,

From the internet or ibm.com ,I really did not find enough info to study sequence stage .

Who have any doc about the sequence would you like send it to me ?

Here is my mail.yunxinghai@163.com or yunxinghai@hotmail.com , as we know I came from china.

Hi All,

Who have video about cognos develop ?,Can you send me via Mail ,here is the mail of my yunxinghai@163.com or yunxinghai@hotmail.com .

thanks.

Hi ,after you changed it ,did you recompiled it . if you did ,i think ,there will be something wrong of you datatype and even you transformer .

Sorry , I think there will no body know for a so long time ,what do you think.

ray.wurlod wrote:Note that you MUST provided a value for each parameter, but you can choose "Set to Default" to use the default value. ...

Hi ray ，

You said use the default value mean which set the job's parameter or user varableStage ,am I right?

Thanks qt_ky and ray ,I think both of you are right .

Hi All,

In one sequence there are five jobs,which job have some same and different parameters ,all of the parameter need to be redefined in the sequence .but parameter 's value in the job do it still working ?

Can anyone has any idea?

Thanks!

Thanks ray,
I think I know what you mean . Yes I create a job and defined a job var in job parameter and set the value to the var in a UserVariables Activity stage and the other stage then reference the var .

what do you think ray?

Hi,All
I got a issue, I want to put the column_1which select column_1 from sysibm.syssummy1 to a varibale ,so who can you please to tell me how i do it?