DSXchange

Create a routine which uses concatenation a1:a2:a3 :char(10):char(13) in loop for no of a3 and output of routine to flat file .... This will help you ..


Thanks,
Anupam

ray.wurlod wrote:An Exception Handler does not cause an abort.

A Terminator activity sends a stop request to all running job, so that their status will end up being "Stopped" rather than "Aborted".

Thus neither ...

Exception Handler + UtilityAbortToLog() routine


Thanks,
Anupam

yalamanchili wrote:Hi,

Than You fro your response.Can You Please Expalin to Me in Breif how to use Aggregator Stage.

Allow row pass through aggregator make all column as group by except one column make that as FIRST/LAST/MAX/MIN in stage.....

Thanks,
Anupam

Use aggregator stage.....


Thanks,
Anupam

hi i have some computed value that i am getting in job1, i want to store this value in a enviroment variable and in job1 only after getting computed , then in job2 i want to use the same value of env varible I think dynamically setting enviroment vairable is not possible... Better go with hash file...

You can also use terminator activity or exception handler...

Thanks,
Anupam

Now problem is solved i passed value of old dept to DEPT and new dept to dummy DEPT and modified update statement...

Thanks all,

Anupam

chulett wrote:Then it should be working fine... right? ...

Question is still there how to pass old DEPT and new DEPT to Update table where we have only one target table DEPT as in tarnsformer while mapping...

Thnaks,
Anupam

DSguru2B wrote:Let it change. You need to pass that as an extra column to your Database stage as a key. No one is asking you to parametrize it.

Yes i am passing Old DEPT and New DEPT too..

Thanks,
Anupam

Routine_Activity.$Jobstatus and Routine_Activity.$Returnvalue both are different Yes, of course... but Routines do not have a $JobStatus - jobs do. 'Executed Ok' means 'returned a zero'. For jobs it is returned as their status, for routines as their answer. But it is working for me here when i test...

If the question is simply how do I use a column twice in the generated sql - once in the where clause and once not - you need User Defined SQL for that. Simple example: UPDATE TABLE X SET Y=A WHERE Y=B Pass the column in twice (different names, of course) once with the old and once with the new val...

Need more info on how did you get the number 30. Are you aggregating the dept grouped by ENAME and then want to go into the table and update all dept keyed on ENAME? Need more clarification on your requirement. one more new table consists of employee information where dept is 30 for employee shifte...

Not much clear with your requirement. What is that you expect to change in If DEPT=30 And ENAME = 'Diana' Then 10 Else DEPT. on DETP derivation. ... I want to update DEPT to 10 where DEPT is 30 In database data in is already exists.... I want to update table with gerated query or userdefined query ...

ok If you see my update statement UPDATE EMPLOYEE SET DEPT=30 WHERE ENAME LIKE 'Diana' AND DEPT = 10

in this DEPT is coming in SET and WHERE clause how datasatge will represent in gnerated one for update

Means updating key column used by WHERE clause ...

Thanks,
Anupam

Target table consists of ENAME DEPT Diana 10 Steve 20 Kane 20 Smith 10 Diana 20 For above if i want update employee "Diana" deparment 10 to 30 where i will get only ename and dept information from source say UPDATE EMPLOYEE SET DEPT=30 WHERE ENAME LIKE 'Diana' AND DEPT = 10 How can we achi...