DSXchange

Column name of an aggregated column has been changed to other than what comes in input. Sort method has kept to Hash.

Partitioning set to Auto.

Column is grouped by 'Name' & calculation is done as per 'Year'.

It worked as expected.

Hi Ray

I overlooked Options category in aggregator properties.

Method = Hash.

Input of the aggregator I am having only 2 fields, which are used in the aggregation process.

Also, I have changed the column name at the o/p of aggregator stage to the other than what I have in i/p.

Thanks.

I am not using sort / hash method in the aggregator. Partitioning type I used is 'Same'. Previous stage employed 'Entire' partitioning. As an input to Aggregator stage I have 2 columns as - Name / Year. In aggregator - Grouping is done as per - Name In aggregations - type is 'Calculation'. Column fo...

Hi I have sort stage followed by aggregator stage. In aggregation I want to know row for max of particular column. After execution, I am getting an abort with an error description as - "main_program: APT_StatReducer: field Name is already present in the output interface schema.". Anyone ha...

Thanks, I gave userid & password it worked.

I have some DataStage projects set to server myserver:9999. I can login with designer & work with them. Problem is, I cannot list projects under this server. I have tried following command for this. dsjob -server myserver:9999 -lprojects I am getting an error code as - 80011 Can anyone suggest m...

We have lengthy derivations within StageVars. It becomes difficult to track syntax or logical errors within this small window.

I was wondering if I can take out these derivations within transformer taken out to some sequential file. Task of reviewing those will be simpler.

I need, Stage Variable name & its drivation.

I came across somewhere, cant locate now, you can retrieve list of jobs. So on the same lines, can we go to the depth to retrieve Stage Var name & drivations?

How can I retrieve details for a jobs by using Universe BASIC?

Say I need to collect stage variables & its derivations within job & write those to some file in a Unix directory.

Thank you very much.

Chulette I am not able to locate -jobstatus, as an option to dsjob. Let me share the command what I gave : dsjob -server $server -user $user -password $password -jobstatus DSRepName DSJobName I am getting - Invalid/unknown primary command switch. We have requirement, to wait until job finishes &...

I am invoking DataStage job using dsjob, within a shell script. In this shell script I have variable declared - SCRIPTS_HOME & is exported. DataStage job has some shell scripts in its before & after routine. Can this SCRIPTS_HOME be available with shell scripts used in before & after rou...

In a sequence job, if any of the intermediate job is aborted, is there any way, it can notify sequence job is also got aborted?

During the reseting of this sequence job, can we have an option to reset all the jobs which are not in a runnable state to become runnable?

1. I dont want to run a job, if it is in aborted state. I need to trap this before executing 'dsjob' from command prompt.

2. Also, I want to detect that job have been completed successfully, & need to trap that code, that the job has finished.

Can anyone has idea, how we can achieve this?

Can anyone please suggest, how we can safeguard passwords, & then can be passed in as parameter value, to a DataStage job?