DSXchange

Hi, I tested the jobs listed in DS_AUDIT table against the result obtained from advanced find today and found out that both the methods list different jobs. For e.g. - I queried DS_AUDIT table - SELECT @ID FORMAT '80L' FROM DS_AUDIT WHERE DTM LIKE '2010-11-02%'; and searched the modified jobs in adv...

how to see the job logs in datastage other than datastage director.

Sure craig,

Actually that post was created by me so I pasted my question on that one and was about to delete it from here. :D ... discussing on this post is fine with me...

deleted the question and posted it here

Hi,

We are facing a similar situation in which a job is visible in designer and not visible in director. Please let me know what could be the possible solutions to this problem.

Would recycling the engine/WAS server help?

chulett wrote:I asked because, unless I was wrong back when I posted this:

chulett wrote:it seems that wasn't added until the 7.5.2 release

Thanks, is there any way out to get maximum value on string column?

chulett wrote:As noted, it's an additional property you can add, just like any of the other additional properties. What version of DataStage do you have?

Its 7.5.1.

anbu wrote:Yes you can do max on string. When you select Column for Calculation, you can see the Preserve type as one of the properties

could you please tell where do i get that? Please????

Where to add this preserve type option? could you pls help me out? I need to perform the max funtion on string column. can i do that?

Thank you all for the support.

Our server is on AIX. We only have clients installed on our machines. Is there any way in which I can contact the AIX server thru my batch script and get the desired result? Some tool other than uvsh and dssh.

I searched for both uvsh and dssh but I couldn't find them.

Craig,

I am unable to find the path to uvsh on my system. Please help me on that. I tried echo %DSHOME% but its not set

Hi all, Thanks for the inputs and sorry for the delayed response. Now i need help in exectuting these commands in a batch file then getting the result in a text file. I can do it in Unix like - $ path/to/uvsh/uvsh "select query" > my_text.txt but how do I do this in a batch(DOS based) file?

Simple and perfect solution. Very helpful :D