DSXchange

I know, tell me about it.
Roy...Need you. Roy

Ok what just happened to my post

do it in the sql itself select A.Region, A.Dept, Sum(A.Sal) As Dep_Sal_Total, Temp.Sal from table A inner join (select B.Region,sum(B.Sal)As Sal from table B group by Region) as Temp on A.Region = Temp.Region group by A.Region, A.Dept, Temp.Sal table A, table B both are the s...

Connect the exception handler to a sequencer with Mode set to 'any' going to your second job. The sequencer will also have another input coming in from the sequencer. This way job 2 will be fired even though the control is passed to the exception handler.

Actually i just tested both your scenarios. I am getting the results you desire. Did you test it.

use this

Dont use trim

Please start a new post.
Datastage will take it as a signed decimal. You dont need to worry about it. Negative decimal numbers are preserved.

Ok. Lets devise an easier solution to get the month. Is your cycle going to run after the first day or on the first day of every month. IF yes then instead of using $counter, you can just do, UtilityHashLookup('Fully qualified path of hashed file",Oconv(Date(),"DM")...

FMT() us bit available in px
User the basic transformer if you want to use FMT()

You dont need to pass $USERSTATUS. just the hashed file name. And yes pass the $counter as the key to the utility.
Do this

you need to set your environment. You need to run the dsenv to set the environment variables.

Told you. THe space is creating the problem.
replace the space from between by maybe a dot.
use this

Well, IMHO, schedule the process only during weekdays OR Right before you start firing your jobs, check for the existence of the files. If they are not there, bypass the execution and elegantly end the process by sending you the email. If you insist on sticking to your design then you can check the ...

mdtauseefhussain wrote:What if we want to bring the date format like this with file name

Sample 2006-07-14 22:25:30.txt

I would still suggest to get rid of the space in between. But if you really want a space then use this

Very true. I, just wasnt sure, if datastage padds spaces to honor the length on its own just by specifying the sql type as 'char'. Thats why my concern to do it explicitly.
But as i told you before, your officially my mentor.
Learn something new from you every day.