DSXchange

Then check with your DBA, ask them how it is normally handled. If that's the case, they can give you the sql you'd need to extract it in a readable format I would think. Otherwise it sounds like you'd have to pull out the binary field and then apply some kind of 'business rule' to decode it. For tha...

By checking that option in the Notification Activity, I assume. You'd have to write your own routine to use the various 'DSGetLog' functions to retrieve just the latest information from the log. That option in the stage does exactly what you've noted, it includes all information up to the current po...

Are you trying to capture the reason in your job and include that in your reject link? Or are you just trying to figure it out for yourself? As noted, unless yours is a 'logical' reject, anytime Oracle (or any other database for that matter) rejects rows the reason will be logged. So, anything like ...

Let us know if you have any more questions once you try this out! First sign of success will be rows moving through the Aggregator at each 'sort break' rather than it absorbing all records, waiting, and only then starting to output records...

The Oracle part is easy. Just need to know what kind of field you need to store it in - a DATE or a TIMESTAMP of some kind? However, the binary(8) part sounds like a 'special' storage format, unless that's normal for SQL Server? If it is 'special', do you know how to translate whatever output you ar...

Sort your incoming data to match the aggregation method. Assert that sort order in the Aggregator using the Sort and Sort Order columns on the Inputs tab. Check the online help available from inside the stage via the Help button for details on the second step. If you do those two things correctly, ...

ajith wrote:There is no initcap function in PX Transformer as such. I think you have to write a parallel routine for that.

Posted as a 'Server' question, hence my answer.

Just for you, I logged into work to get the gory details on helping you help yourself. Turns out this particular 'task' isn't listed where I pointed you, although many others are. However, going to transforms (server jobs) in the Index does turn it and its brethren up in the string sub-category. Sug...

Yes. First suggestion would be to check the BASIC section of the online Help. There's a part where it lists functions based on what kind of operation you need to do. You would have found your answer there. Direct answer is there is an OConv conversion code to do this, but I don't recall it off the t...

narasimha wrote:You coudld also use Oracle NVL function...

Really? Where did anybody (other than you, that is) mention the 'O' word?

Oooo... metasyntactic variables.

Somehow job A is waiting for few minutes before starting There really isn't any way for the Sequence job to 'delay' starting JobA unless you have activities in the Sequence job before the Job Activity stage for JobA. One situation I've seen that confuses people is if JobA has a 'before job' activit...

That was Bill, or Chuck or whatever 'nom de plume' DSGuru2B is operating under today. As noted, you can do this in your SQL or in your job - your choice. Typical SQL solutions could include NVL or DECODE or COALESCE, for specific answers we would need to know your database. In the job, IsNull could ...

Short answer is 'yes'. For a longer answer and many discussions on solutions, suggest you search for some of your error messages. For example, an 'Exact' search on Cannot open executable job file would be a good place to start, I would think.

Why not a routine that reads the file and set the value as Userstatus for that stage and pass as a parameter to the Looping stage. Routines don't have a UserStatus area, so can't set it for 'that stage'. It could, however, pass it back as 'Command Output' as noted earlier. I keep telling you to use...