DSXchange

That's the first step.
You need to find the actual executable.
It is in you $DSHOME/bin directory.
The directory has to be in your path or you need to specify the path.

orchadmin -help

orchadmin -help

Check out hash partitioning and sorting, transforms and stage variables. Hash partitioning gets the "like" data in the same partition, sort it in the right order, store the previous cumulative in a stage variable, add the stage variable to the new input row, output the row with the new cum...

Check out hash partitioning and sorting, transforms and stage variables. Hash partitioning gets the "like" data in the same partition, sort it in the right order, store the previous cumulative in a stage variable, add the stage variable to the new input row, output the row with the new cum...

Is this for server or parallel? (server in heading, but in the parallel forum)
In server, I get the same result (your Toad result) in both the view data, and SQL Developer (Oracle's answer to Toad).

It would have come on the distribution media for QualityStage. Or else, you'll need to contact IBM for assistance with downloading it. It should be a "no charge" item.

Do you have the QS plugin for DS?

If so, run the DS package installer ($DSHOME/bin/dspackinst) application from the command line. It asks you for the directory where the plugin resides, and what DS projects to install it into.

Run: select * from nls_database_parameters select * from nls_session_parameters select * from nls_instance_parameters in each environment and see if the time and date settings/formats are the same. If not, that could be a place to start looking for the problem. We've had similar problems. Best to ru...

Unless you're using Version Control, then your logs stay around. (How? I don't know. Magic, I think.)

"dsjob -import" from the UNIX command line only accepts a DSX file, I'm pretty certain. That's why it is complaining about the BEGIN HEADER.

You can import the xml from with windows client command line via dscmdimport.

Or from the DataStage Manager GUI.

Make sure there are no directories under the directory that the folder stage points to. Put a file in there that is a bit smaller than 2GB, and another file just over 2GB. If it picks up the <2GB and doesn't read the >2Gb file, then you may need a patch from your service provider to support files gr...

Betcha a donut the last time you accessed one of these stages you had two screens...and windows is displaying it now on that "other" screen that is no long attached. Reattach the other monitor/screen, open up the job again, open the stage, drag the screen back onto your primary display, sa...

Try reading the dataset and a row generator into a funnel and then into the transformer. As chulett says, you have to have data in in order to have data out.

Try reading the dataset and a row generator into a funnel and then into the transformer. As chulett says, you have to have data in in order to have data out.