DSXchange

Do you want to call unix shell from DataStage or Datastage job from Unix?

Custome - Routines.
From Designer/Manager, right click on routines and Say New Routines.
There you may need to configure the compiled object code of the C++ program.

Hi, That is a shell script created. Say MasterControl.ksh . It need to be created in unix, either using vi command. >vi MasterControl.ksh {past the the whole code and save the file by Esc:wq} This shell can be directly call or scheduled. It require 14 parameter to be passed. If you look in to the sh...

If you mean Orchestrate operators guide, search here (dsxchange), you would get the path provided in Ascential website.

It should move the file. Check your return code or error log of the command used for more info.

Vincent has already shot a blog on this. :D

Can you explain your job design, APT_ParallelSortMergeOperator indicates the data collection part where it has been collected uneqully among the existing nodes. It it a sequential file at output?

Have you checked for the disck space for all the nodes where the dataset lands. But still, it shouldnt give you this inormation.

If I understand you requirement, you need to configure your partiton for each run by chaing the apt file in the follwoing line ErrCode = DSSetParam(hJob1, "$APT_CONFIG_FILE", "/dstage/Ascential/DataStage/Configurations/8 Node Configuration.apt") If Iam right, what stops you to use parameterize the f...

Stable sort will help to maintain the same position of the data with in the group as it is from the source.
If this is what you are looking for.

Use stable sort option.

Have a parameter file in the following formate Filename1 = filename1.txt Filename2 = filename2.txt ... ... With the below code, you can call the job with each filename in a loop. For each time you can change the parameter file for configuring the filename. OpenSeq <filename> to vFileVar else Call DS...

Now I get a doubt whether you could able to make use of parameters in the code. But let me make sure, you have used the funciton as Call DSLogInfo(..) right? Hope you also have INCLUDE DSINCLUDE JOBCONTROL.H at the start.
But the best way is to read the parameter from an external file.

Hi Ramesh,
Are you trying to say something

Check the post "Difference between Transformer Stage and all other stage". You can also find the controversial fact given by Pneuma Lin and opdas. you can also find the interesting Vincents bog.