DSXchange

poonamgoyal wrote:what is the need of creating these aliases as it ll add to performance overhead i think

If you look at query you will understand need of aliases and it wont add any overhead ,just increases your readability ...

Thanks,
Anupam

What's wrong is that Ans must return zero if an OK trigger is expected to fire. ... I think Routine_Activity.$Jobstatus="Excuted ok" thats return 0 thats ok But here is Routine_Activity.$Returnvalue should be equal to 0 is that you mean to say here i worked with keeping trigger as condtio...

SELECT A.CPY_0, A.FIYNUM_0, A.PERNUM_0, TO_CHAR(A.PERSTR_0, 'YYYY-MM-DD HH24:MI:SS'),
FROM #LNomDos#.PERIOD A
WHERE A.PERSTR_0 = (SELECT MIN(B.PERSTR_0) FROM #LNomDos#.PERIOD B WHERE B.CPY_0 = A.CPY_0)

One more .. Previously totaly overlook..

Thanks,
Anupam

well i have some simple query using subqueries if you want to try: SELECT PERIOD.CPY_0,PERIOD.FIYNUM_0,PERIOD.PERNUM_0, TO_CHAR(PERIOD.PERSTR_0, 'YYYY-MM-DD HH24:MI:SS'), FROM #LNomDos#.PERIOD WHERE PERIOD.PERSTR_0 IN (SELECT MIN(TO_CHAR(PERIOD.PERSTR_0, 'YYYY-MM-DD HH24:MI:SS')) FROM #LNomDos#.PER...

Anu,

There must be something else worng ... I dont see anything wrong in routine and keeping trigger as condtional = "Executed ok" ...

Thanks,
Anupam

Did you try DSWaitForJob(JobHandle) ?


Thnaks,
Anupam

But you are converting date to char and then applying the MIN to char value I think it should be.. TO_CHAR(MIN(PERIOD.PERSTR_0), 'YYYY-MM-DD HH24:MI:SS')) ... It didn't work for me when I tried using what you have mentioned and hence I stuck to what I mentioned and it was working fine for me i.e. g...

MIN(TO_CHAR(PERIOD.PERSTR_0, 'YYYY-MM-DD HH24:MI:SS')) Won't look correct .......... Will it give desire result......... Will work as good as it can :wink: Yes, it gives desired results. I used the MAX function many a times. So, shouldn't be any different for MIN function. But you are converting da...

Try this SELECT PERIOD.CPY_0,PERIOD.FIYNUM_0,PERIOD.PERNUM_0, MIN(TO_CHAR(PERIOD.PERSTR_0, 'YYYY-MM-DD HH24:MI:SS')), FROM #LNomDos#.PERIOD GROUP BY PERIOD.CPY_0, PERIOD.FIYNUM_0, PERIOD.PERNUM_0 or you should also perform some kind of aggregate functions on columns PERIOD.FIYNUM_0,PERIOD.PERNUM_0 ...

kumar_s wrote:Do you mean writing the record id as file name for each set of group.

Yes... Kenneth has given solution ... and it works fine ...
Just in concatenation put CHAR(13) and CHAR(10) for new line...


Thanks,
Anupam

First check if the project is a protected one, this you can check in Administrator client. Administrator or root user can unprotect a protected project. You can do this and then make the changes. Regards Ashwin Ashwin , Protected project only protect jobs design , we can perform tasks that affect t...

Try with folder stage and aggregator stage...

Thanks,
Anupam

Delete file in before subroutine and keep file option as append....


Thanks,
Anupam

[quote="adams06"] how can we convert this nonnumeric data(A1) into numeric. /quote] I did not get what numeric value you want for (A1)... But you can use NUM() to check whether come value is numeric or alphabatic for numeric it will return 1 and for alphbatic 0.. Give the condition like if...

You need to give it condition for insert like InputLink1.NOTFOUND or InputLink2.NOTFOUND and ..... Upto 8 links and for Update NOT(InputLink1.NOTFOUND and InputLink2.NOTFOUND and ... Upto 8 )
above should be fine..

Thanks,
Anupam