DSXchange

Wasn't asking about the "target" column as in the end state, I mean the column it will land in first, the one in your source stage. That's the one it is complaining about.

Also... give us some context. Is this the first time this product has been run? Has it been running for some time and this problem is new? If the latter, is there anything 'unusual' or out of the ordinary that was done just before this?

What is the datatype / precision / scale of the column this will end up in? ABS() isn't part of the problem, btw.

What "all possible ways" have you tried?

koolking wrote:Run the Delete Initial Hash Load

Sorry, don't know squat about the canned PS stuff but wondering... did you? If not can you?

If the SQL from the log executes fine outside of DataStage without any changes, double-check your target instance in the job. Perhaps you're not selecting from the table / database that you think you are. If that checks out, involve your support peoples as that smells like a Connector issue to me...

Your query looks fine. What does the SQL look like at runtime - have you verified that you've matched the parameter name spelling and case as well?

As to the other, try tripling the size since you're probably fighting a bytes v. character issue with the precision setting.

Was wondering if it was obsolete by now or not. That is such an old feature... I recall working with and worrying about it back in the 3.x and 4.x world, I do believe. Once Version Control came out it was pretty much obsolete and I never used it again... and I'll wager most people never used it at a...

Typically used for lookups. If you have any Informatica experience, I can make a comparison if that would help.

I assume the small retailer is WalMart. And "smalls" or "small clothes" are underwear. In case anyone was wondering.

This may just be me but I consider routine writing an essential skill needed by a DataStage developer. But then so is knowing when to use a Server job for something.

This would be pretty simple as far routines go so (IMHO) a good place to start the learning ball rolling.

It you haven't done so already, you really should involve your official support provider.

prasson_ibm wrote:Can not i call it in stored procedure stage.

I would certainly think so, yes.

Of course... and all of the other ones you didn't see before I removed them.

Takes the site owner to shut them down, I've sent them a message.

As noted earlier, you're not checking the directory you think you are.