DSXchange

I don't have any way to test this, but going on the way things used to work and assuming they still work the same - all you should need to specify is the job's name since that must be unique per project. I can't imagine you're also required to mention where it lives.

So... rather than attempt to answer the questions asked or add any new information to your post, you simply repeat the initial post word for word? Seriously?

From what I recall, the older posts discussed routines that you could get if you engaged IBM consulting services, routines that are part of the package they bring to the table. I don't recall any talk of them just showing up in a new / later release, but others might be more in tuned with news of th...

if extract_1 failed i do see aborted state and i have to manual reset it No, you should not have to do that as long as you have the Job Activity stage set to "Reset if required, then run" as you've noted That's the whole point of that option, to avoid the need for a manual reset. That &qu...

Not sure what you are asking. That "Reset if required, then run" option in the Job Activity stage should mean there is no reason to need to "manually" reset them after they abort. Can you be more specific about your issue?

Those are only valid for use in a BASIC routine or Server/BASIC transformer, as far as I know.

Or I could just split it.... <snip>... done.

grogash - please edit your post and set your particulars - O/S, version, etc - unless by some chance I guessed right.

Here is the original thread, by the way:

viewtopic.php?t=136594

He did.

What you found for the Modify stage should work fine as well.

Have you involved your official support provider yet?

Ok, view data may not work but does the job run?

Why over-complicate it? As noted, you can "match" the first four characters of the string like so:

For that you could just check the first 4 characters using the substring [] operator. For a check inside the string, investigate the Index() function.

If literally the only change was an upgrade to 8.5 then I would suggest opening a case with your official support provider to see if this is a known issue.

They've already posted the issue and the fact that it was resolved, so unsure why you are bringing scale into the picture, it doesn't really seem relevant here.

Welcome. :D The DateFromJulianDay function isn't working for you because what you have is not a Julian date. What you have is an Ordinal date which combines a four digit year with the ordinal day number in that year for the m/d portion. You've been given the proper way to handle them by our friend j...