DSXchange

Hi Rajender, Even i am doing that in job control. [b]I just wanted to you to paste the code that generated in the sequence not the sequence [/b]and use the variable in that code in your mail syntax. Anyway you are using Dsendmail routine which is used by emailnotification stage. Either way you can d...

Hi Rajender, I have the exact requirement and i am doing as follows: Create the jobsequence with the jobs you want and for each job add a email notification stage ( if you want to send each job log as email) and check the jobstatus check box in email notification stage. Then compile this job and tak...

Hi James,

Ok my mistake, DSJ.ME IS nothing but jobhandle for currentjob. In that case i was using the same code you gave me. But james, did you find any way to get more deatailed mesage as i have explained in my earlier message.

thanks
sandeep

Hi James,

Thanks for your quick reply. I am using the same code you gave me, but i have used a jobhandle insted of DSJ.ME. Ok any way let me try what you gave me.

Thanks,
sandeep

Hi JAMES, version:6.0 server:unix Could you please post your code as i need the same thing. Right now i am using DSLOGSUMMARY to capture the log and send it in email, but as you know It won't give you the more detailed description of the warnings or errors( i mean as you see in event detail window) ...

Hi guys Thanks for your quick reply's. I am using some if else operators and 3 stage variables. The same job with different dates (as i am passing start and enddate as parametres in source oracle stage) working fine without any warnings. Even this one has finished ok , but with this warning. Any clu...

hi Folks, I am getting the following warning while loading a target table. The job has finished successfully, but i am getting this warning. DataStage Job 1201 Phantom 2034 Program "JOB.981326942.DT.1355634165.TRANS2": Line 134, Variable previously undefined. Zero length string used. Progr...

Thanks very much .it's working the way i want....

Thanks very much... I working the way i want

[quote="ArndW"][quote="kduke"]There is SAMPLE 1 which I have no idea if it works after an order by clause.[/quote]

The SAMPLE uses a record key position within internal hash groups, so you will never know what value you will get.[/quote]

Hi I have situavation like this ...i am writing data to hash file and same hashfile using as reference table using UniVerse stage...when i passing my criteria it returns more than 1 row . I am using order by clause and sorting on date field but i want only top 1 row.. is there any pseduclolumn like ...

Thanks Very Much....

Use Pivot Stage.
Output Column Derivation
Key Key

Code Cd1, Cd2, Cd3

Hi DS Folks, I have situavation where i want to use greater than (>) or Less than (<) operation with hash files while joining ..Usually when we use hash file as reference internally is uses outer join to join with source ... i want to use relational operaton while querying hash file....[size=12][/si...

hi Roy

I have Searched the forum, but i didn't find the exact answer. That's why i have placed the topic. OK anyway thanks. Iwill try and let u know

Thanks
sandeep