DSXchange

The configuration file name used to create dataset should be set to APT_CONFIG_FILE while deleting the dataset with orchadmin command.

-jobstatus waits for the job to complete, then returns an exit code derived from the job status.

Please check if your &PH& directory is filled up. I remember once we had problems like this and we cleared the &PH& directory. Just check this out or wait for the expert comments.

Ray thanks for your response. I will be sorting out my premier membership soon.

Yes we cannot do any aggregations on string fields in aggregator.

Can you explain what is a web character?

I remember DS_AUDIT is one which stores the information about the jobs.

Generally this component has to used for the clients we process the data. Suppose if we have 5 clients today we will have 5 different file formats and the file formats will increase if the number of clients increases. The input files can be CSV files with the first row as column names. Can we read t...

We are planning to design a generic component in datastage with the following specifications. It has to read the metadata of a file at run time. It will contain different keys for different file definitions. Then it has to perform the aggregations at runtime based on the file definitions. The field ...

One way is to do a look up on the same hash file for existing records.If you try to load the records without doing a lookup you will get a warning for duplicate records.

Are these sub routines are unix shell scripts??
Are these sub routines are of same type.

Just to add to the previous post nobody should access the job during the export and import process.

You can covert a single job as a read only job with the following approach: 1) Export the single Job from datastage to your local machine. 2) Change the Flag value in the souce code from 1 to 0 to make the job read only. 3) Reimport the job to the project folder now the job will be read only. Please...

Can you please reset the job from director then you might get some more information about the abort. That will start with the lable " From Previous run ". Please post the same so that people might able to analyse the problem. :D

Hi hema, I had totally 4 coulmns in my table where first 3 columns are hey columns and the last column which is not key column is missing the data in hash file where the row exists in database . tried in many ways but in vain. pls help me here Might be a crazy question. Can you check if the order o...