DSXchange

("U" is not the correct word, please use "You")

Yes, the virtual datasets are present in the memory of the node on which the job is running.

how about telling us what your syntax error is, that might be easier.

You can do it using this command

My test file just had 1 column with a date in the format dd/mm/yyyy. I declared it as type "date" and sorted it, then output it as type "VarChar" to another sequential file. When I changed the output to "Date" as well I get the following warning: TestServerSort..Sort_4: At row 1, link "DSLink5", whi...

As a datastage user enter "ulimit -a" at UNIX. Better yet, add "ulimit -a" to a ExecSH call in your job's before-job routine call and view the result in the log file.

Precompilation also happens in PX jobs so the question can stay in this forum. But I have to admit I don't know the details of exactly which components belong to the "precompile" phase. Quite a bit of the compile happens on the PC as well as on the DS server.

You can call dsjob on server A and tell it to start a job on DataStage Server B. If you can "ping" it and it has DS installed and you have a valid userid/password combination you can issue dsjob commands to your heart's content.

The DataStage clients cannot be installed on unix. You can start jobs on UNIX using the "dsjob" command - even remotely.

Your format string should match the data as in "%yyyy%ddd"

Go to the list of stages -> Parallel -> Processing and then drag-and-drop the BASIC transform stage to your canvas.

How many Mb are you looking at? If you use the API then the DataStage server controls when and how to do the job run. If you need to extract & ftp the data then another group is involved and controls if things will run. This would be push instead of pull technology.

At Version 8 this works. I assume that when the DataSet is being deleted at V7.x it is taking the currently active configuration file instead of using the one stored within the DataSet for the delete operation.

keshav0307 - could you post an example of how to do that please?

The the BASIC transform stage still exists at V8

All links have the same purpose, they depict in which direction data flows between two stages. Link Names are a matter of policy and standards.