DSXchange

If you are familiar with the server edition, go to the conference in Dallas, Texas, supposed to be very good.

James

Sandeep, DSGetLogSummary (DSJ.ME, DSJ.LOGWARNING, DSJobStartTimestamp, DSGetJobInfo (DSJ.ME, DSJ.JOBEOTTIMESTAMP), 2) I've used this code which gives me 2 entries, put 0 instead of 2 which gives you all the log, be careful in using this option, it limits the no. of events you can get from the log. J...

Thanks a lot guys, all the info was very helpful,
I've used DSGetLogSummary, and also other DS functions, and did some tweeking,
Regards
James

I could use this function only in the JOB CONTROl, but I want to use it in the same job that throws the warnings. it's like I need to get the message when it logs it in the Director. I'm sorry If I'm being a pain in the neck. but please suggest me how to do it. Thanks your help is really appreciated.

Could you please tell me where to find Log Detail option. I couldn't see it in DS functions, or macro's
THank you for your Help
James

In my job I'm sending all the rejected reocrds to a procedure in which I would like to capture the warning message, this should happen at record level, like using a "outputlink.DBSCODE, which gets me only the DBSCODE but I need the whole message", for example this is the warning message I'...

HI, I was wondering if I could capture the Message from Event Detail WIndow from Director's log, so that I could use it in the job and send that message to a table.
Thanks in Advance.
Regards
James

Hi Abhinav, I beleive what you are doing is updating the same hash file, I mean try this design Hash A | | V SRC--------------------------->XFM------------------>TGT | | | V Hash A if this doesn't work then you will have to use two transforms, first one look-ups the Hash A and the second one updates...

HI, I have a question on this, Could I somehow only write a record to Hash A(Output) which is only written to the File A. I mean can I not write the records(into Hash A) which are not written to the File A. for example for some reason the row is rejected or not written into File A but the Hash A get...

HI Ray,
I just added one more Transformer to the design, I mean a second transformer which updates the HashedFile_T14. It works ok.
Thank
James

Thank you Ray. I'm gonna use the Sequencer. but there is one more thing I need help with, I'm trying to dynamically update the HashedFile_T14 from the XFM. but it doesn't let me do it, when I try to compile, it says "Job contains cyclic or linear dependencies and will not run" any idea as ...

The is my job: LKP_For_T14 | | | Src_ORA --------------> XFM---------->T14 I'm loading T14 and I need to do a initial load and loads after that, Like when I run it first time I don't have any records in the table T14. and The Constraint in the Transformer is : T14.Column1 <> Src_ORA.Column3 then loa...

Thanks for all the suggestions, I checked the fully generated query I've used, for some reason the order wasn't right, then I did a userdefined SQL query, and with the necessary timestamp format, it works fine. but still I wonder how could that happen, the generated query did a mismatch of the order...

I spoke to my tem leader about that, he was like, I don't know what I'd be rejecting the columns, he wants the database to reject them and send them to a stored procedure using which an entry is made into a table where the details like an insertion into DB failed for whatever reason it is. and stuff...

Oh Cool,
Thanks Craig, I didn't know that jobs with warnings wouldn't cause problem in production, thats why I was worried about that.
Jamy