DSXchange

Could you post what your resolution actually was, please? This will help future searchers with the same problem by having one more place the find The Answer.

Interesting... I had assumed you'd done the required bind since you already had working jobs talking to DB2. Perhaps that's because you used some other than ODBC to import the table metadata.

Regardless, can you please mark this as Resolved using the button at the top of the page?

Assuming your connection information is parameterized, make sure the value you are passing is correct and the parameter is resolving correctly. Right now, it can't find what you passed in in the tnsnames.ora file.

Worst case you could build a lookup with the 20 values to substitute for the last character and do all that while it's still a string. The link I posted showed you that a 'P' would be a -7 as the last digit. You'll probably want to handle the signage separately and multiply the result by -1 for the ...

Yes, one ships with the product, or at least it certainly used to. The pdf documentation is also something you really should go through and there's an IBM Redbook with lots of good information in it, free for the downloading.

As noted early on - unless you have an FD that says otherwise and then we have "issues" - those are not comp-3 fields aka 'packed decimal'. They are zoned decimal fields.

As noted, that "does not exist" error can mean either exactly that, or you don't have the grants you need so it is (in essence) invisible to your user. You'll also find you need "extra" grants to truncate and load a table rather than simply "upsert" data into it.

Confusing.

So, you're showing what it should be? Why not show us what you did get? Post that and your transformation logic so we have some clue what is allegedly going wrong. All you've said so far is "it doesn't work" which is singularly unhelpful.

You should if-then-else around those zero dates, I would think.

Deleted is deleted. What kind of backups do you have?

Install the 8 client, even if you have no 8 Server yet. This will give you the documentation you need, including 'Migration Guide' and a 'Planning, Installation and Configuration Guide'.

What 7.x version?

I'm not aware of any "cons". Make sure you have good backups and then allow the new version to overwrite and upgrade the older version directly.

The Redbook. Or here if you want to purchase a printed copy.

If your output column is nullable and you're fine with them, then there's no need for null handling. Do it when your target does not allows null - even if there will 'never be any' - just to shut PX up.