DSXchange

Ah... forgot about the PADCHAR variable and the fact you can control it inside your job. So, the default is to pad with "nulls"?

Hmmm... interesting you would specify a size in megabytes rather than a character count. We'll need to see what one of the Grognards has to say on the subject.

At the beginning of your command string. Open a "cmd" window and type "start /?" to get the DOS help information.

Works fine for me. What exact version of DataStage do you have and what flavor of UNIX is it installed on?

And by "join" you mean in the database / sql sense rather than say, concatenation, yes? What are your rules for "joining" a char(1) with a char(3)?

I don't believe that is valid (or prudent) to use with the 8.x release.

Perhaps silly, but what happens if you say "UNIX" rather than "NT" for the O/S? There is a DOS find command, by the way, perhaps it is using that rather than the MKS version. Or just make sure the MKS directories are first in the PATH... are they?

Joining to another char field of the same size? If so, then no trim needed. If something else, then please explain.

Are you asking how to store a separate time value in Oracle? Typically that would be done as a VARCHAR2, i.e. as a string. Or put both pieces into the DATE field.

You can't trim spaces from a char. Why not simply check for = 'IN ' instead?

No worries, I question that statement as well. Seems like they aren't properly linked together, which is why I put up a little ASCII art.

Yes.

What will "not be the case"?

"All" in a Sequencer means all input links must "fire" before anything passes out the other side.

Depends on if they are "pathed" hashed files or were created in an account. For the former, yes you can simple copy them over to the new server using your tool of choice. Make sure you get everything, including the hidden file for a dynamic (Type30) hashed file and the "D_" dicti...

Don't know for sure, but pretty darn big... assuming max string size for your machine architecture. What kind of sizes are you pondering using?