DSXchange

Convert only works on strings, as does your comparison... and trim.

You have 'the same problem' and I have the same question - how would you call it if you were not using DataStage? The answer to that question will lead to the solution.

Or you can always involve the experienced people at your official support provider.

Post your derivation code and let us know the data type of the field you are using it on.

techsavy wrote:Thanks Franklin. I think I can write similar logic to Check all positions instead of only first position. Right?

Why if they're always all of one or the other? I suggested checking one character because that's what you stated. But...sure, if you feel the need.

Amin - have you been able to make any progress on this? Figured out what is going on?

I remembered.

So perhaps simply substring off the first or last character and check that.

That sounds like a support question to me. Also, I wasn't asking about the creation of the tables but rather the databases, since it seemed like you were talking about two different ones... or are 'staging' and 'work' in fact in the same database?

techsavy,

Please make use of the lovely Reply to topic button, there's no need to be quoting everything you are replying to all the time. The DSXchange Janitorial Service thanks you.

See if the last post in this discussion helps.

So a characterset problem. Do you know what characterset your DB2 database is using?

So... a script. And not a lot of other information to go on. I'm not sure how anyone can answer your question without seeing exactly what the script does and thus what "to get data from different files" means. At this point we don't even know if the ESS is what is "hanging" for y...

<split out to your own topic>

If you need more help, detail for us your error.

So use a Sequential File stage then. What purpose is the External Source stage serving here? "sh filename" is fairly meaningless as a source filename... is that "filename" a script?

FORTRAN and PL/I? Sheesh.