DSXchange

To use job parameters in before/after job subroutines. You need to enclose them in a pair of # symbols. And it's the same even with environment variables added in job parameters. For instance, If you want to pass the value of an environment variable "foo" (added in job parameters) to a dum...

You *can* call server routines in a parallel job from a basic transformer stage, As Ray pointed out earlier the problem may be with the routine. Create a simple routine which accepts a dummy parameter and returns a hardcoded string "HelloWorld" to the output. Test it using the basic transf...

Assuming that you have a maximum of two records with the same values for col1 and col2 in IP1, and also assuming that the order of col3, col4 doesn't matter. You can do it using the following design IP_FILE1====>copy============ | | | | | | V V IP_FILE2====>Join==========>Join=======>Pivoting logic ...

To rephrase what Craig said:

You can find a few resources on my blog http://minhajuddin.blogspot.com and there is an excellent article by Vincent on the history of Datastage in ITtoolbox.

You can use psftp or fsecure to transfer files using secure FTP.

System Variables in which context?

If you are talking about Environment Variables. You can get all the information on them by reading the Parallel Job Advanced Developer's Guide.

Maybe you can put your OSH code in a post, that way people will be able to analyze your problem better.

.. And let us know, what you mean by "not working". Does it throw an error? Or does it give you some unexpected output?

Why do you want to do this in a Transformer stage? If you want to look at other options, you can use a Tail stage to get the last record in each partition or the last record in any of the partitions. Or if you want a really funky logic, you can hardcode a value in a new column (say dummy='x') and th...

Thank Vincent, He was the one to first blog about it. ( I took the liberty to reference it in my certification resources)

Which "arithmetic operation" do you want to do?

Welcome to DSXchange :D Please post specific questions, Questions like the one you posted are too generic. Datastage and Qualitystage are two separate products(which have the same designer from 8.x onwards). Follow the instructions in the instruction manual which comes with the CD and if you face an...

arnabdey wrote:Can anyone please reply me what are the exact settings of these environment variables in Windows 2003 Server (and if possible in Windows XP)?

Thanks

Have you tried the things posted above
If so, what is that didn't work for you?

Try using the sort option in Aggregator without the sort stage (Not that the data has to be sorted, But Datastage inserts a tsort operator and sorts the data on the right columns). See if it makes any difference.