DSXchange

Thanks All for your responses. We do not want to toggle the jobs between RO and RW modes, as the developers will regularly be working on their respective jobs. So, this work-around is not working for us. As I mentioned, due to some biz decision, we can neither create separate projects. I understand ...

Greetings to All ! Requirement is to restrict access/ protect/ hide a set of jobs placed under a specific category from a group of developers. Ideal would be if they can be barred to access a particular category. Even if they have Read Only access is acceptable. Kindly let me know if there's a way t...

Appreciate your help!

Thank you, Craig.

Hi DSXians, We have decided to upgrade DataStage from v7.5.1 to v7.5.3 in our project. During upgrade, we want to run both the versions in parallel for a short period of time, from testing perspective. Needless to say, both the versions would coexist, and on the same Unix server. My questions is: Ca...

Thank you, Craig.

Hello,

In one of my projects, we are upgrading the DataStage server from v7.5.1 to v7.5.3. Currently, we are using v7.5.1A versioned DS clients.

I'd like check if v7.5.1A clients are fully compatible with v7.5.3 server (Unix based).

Thanks in advance!

Use IsValid('DATE' , In_Date_Column) in Transformer stage

Check job log in Director for errors.
Post your sequence job design along with the error messages if you're unable to resolve.

As Vasanth mentioned, INTEGER is a valid dataype in Row generator.

JulianDayFromDate(defaultdate) - JulianDayFromDate(CurrentDate())

OR

Use DaysSinceFromDate() function.

Abhay, your question itself is not very clear. Do you want to capture all the records that occur more than once, and also the count of occurences? If yes, then try the following logic: Use a copy stage to split the incoming records into two streams. One stream goes to an Aggregator stage that groups...

Hmm, so as a workaround I have written a small script that fires RUNSTATS statements, and calling this script from Execute Command in job sequence.

Thanks for the info, anyway!

Hope DateFromDaysSince(-1,Stgvar1) should work in a Transformer!

Define the datatype of your stage variable as DATE

Thanks stefanfrost1 for your response.
Is it a limitation of DB2 API stage or it is supposed to behave this way?