DSXchange

Create a environmental variable PWD and add the path which points to your project directory. "/etld/etl/ascential/Ascential/DataStage/Projects/MARINA".
Or you can alternatively specify '.', which is the CWD.

Pretty good alternative.

1. Most probably yes (as per documentation), but If I were you, I wont take risk to leave Datastage to decide upon the partition. I ll do it manually. 2. Yes if both the streams are partitioned on HASH on the lookup key , and if you are sure that both will be partitioned exactly the same, it will wo...

Once the file is written into to OS, it could not discriminate whether its from Server or parallel job. Unless its specific file types like dataset, hashed file etc. If I understand properly, in your case,you are trying to match between a Sequential file produced by some PX job and a Hashed file pro...

Once the CD is mounted in Unix, you should be able to access it as usual.

If it decimal, FMT(in.Col, "9'0'R2") this should take care.

May be its trying to pipe the output of the command previous to the '|' and hence failing. As mentioned, creating a new file with this command in before job subroutine will do.

OP is referring to the one among various Record type option available in CFF stage. The other types are Fixed, Fixed Block, Variable, Variable Block, Variable Spanned, Variable Block Spanned, VR. Except, VR rest were given with some explanation. I guess VR should be some thing related to Mainframe s...

Do you think this topic can be marked as resolved?

For Unix/Linux the new line character will be LF (\n)
For windows its CR+LF (\r\n)

Path for files, and Delimiters should be taken care. Rest of the stuff are pretty much compatible.

Your mail server should be configured for that different network. Try with your corporate mail id as From and To.

The other post is duplicate post of this, but with different heading. Delete that, and edit this current post to add required information.

It can be done based on other events like WaitForfile. But for Upate or Insert, create a trigger in database, which will produce an empty file in some specific directory. Based on that file you can trigger sequence.

Was the receiver in different network? Check your own email id.