DSXchange

A search on 'Non-positive length' turned up zero hits, so no-one has posted about it before. To me, that looks like the kind of error that only the vendor would be able to track down. I'd suggest you contact your official Support provider and let us know what comes of it.

It would be the time on the DataStage server, not your local PC, if that's what you are asking. Otherwise, I'm not sure what the difference between 'server time' and 'system time' would be.

Vinod, you've got your 'conv' functions backwards. Ray's check will ensure (amongst other things) that the year portion of your dates are four digits. If that's good enough, go for it. If you need a tighter check than that, that the year falls within a certain range, then you'll need to check the ye...

Pass back a non-zero return status from your script if anything goes wrong in it. The job will notice.

Ok, go ahead then.

If you've tried already and it's "not working" let us know what you've tried and what about it isn't behaving the way you want.

Short answer: no. Slightly longer answer: no, but you can skip step 1, it's not needed.

Well, that's certainly one way to solve the problem. And at least you *had* a backup!

I'm guessing your issue is the fact that you would want your three example dates to be declared 'invalid' - the problem is they are perfectly valid dates. Seems like you'd need to do any standard date checks you currently are doing and then add in a 'range check' for the year - a business rule that ...

You have 'around' forty key columns in the hashed file? I can't imagine you actually need all of that, can you? What in the heck are you looking up? But, yes, there is a maximum limit on the combined size of any Key columns. It is configurable, however, and you'll find it in the uvconfig file. I str...

No problem. And I see you did mention the fact that COUNT returned an error, I should have dug deeper into exactly what error it returned.

Unfortunately, that's far from anything 'generic' but a rather bad issue. Good luck. As other folks come online here, more suggestions may be forthcoming.

What am I missing? Nothing, other than the fact that you cannot use a routine in a Job Parameter's default value. You have been led astray. Note Ray's answer - Sequence job, Routine Activity stage, downstream Job Activity stage takes the result of the routine call. If you want a 'GUI' solution, tha...

Ah... I see you finally made it over here, Sreejith, the right place to be looking for your answers.

As noted over on the IBM site - LongVarchar.

What database and how is it defined there?

Maveric wrote:See if these routines from Ray warlod's site will help u.

http://home.iprimus.com.au/raywurlod/services/CustomCoding.htm.

That would be because of the period you added at the end of the URL. It works more better without it.

Same error as before that you did not mention before. That's a completely different problem. Did you have space issues where DataStage is installed? A portion of the Repository has become corrupted - a 'blink' is a 'backwards link' error and from what I've seen is the result of space problems or per...