DSXchange

Hello, I am able to compile most of the jobs which have transformer stages. Only few ds jobs are giving me these errors.I am not sure why I am getting these error for certain jobs. I checked the environmental variables; APT_COMPILEROPT O -q64 -c APT_COMPILER cxx /usr/vacpp/bin/xlC_r APT_LINKER cxx /...

I also received this message;

##W IIS-DSEE-TFTM-00012 16:05:50(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".

Thanks
Mark

Hi All, when I try to compile a data stage job in version 8.1 I am getting the following error message at a Transformer stage; #E IIS-DSEE-TBLD-00076 16:05:50(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 64512. ##E IIS-DSEE-TFSR-00019 16:05:5...

Hi All,

when I try to compile a data stage job I am getting the following error message;

Fatal Error: An ORCHESTRATE program must be started on a node
in the configuration file. The configuration does not contain the invoking node.

data stage version: 8.1

Please advice.

thanks
Mark

Thank You.

Hi All, How do I capture a reject file with sql code and sql error using oracle enterprise edition stage. I am trying to insert 100,000 records into oracle data base. if there is only 1 bad record it rejects all the 100,000 records with a sql code 1403. I want to capture only the specific record(s) ...

Thank You.

For now I need 10 output files. In future if I my client needs 100 files then my design becomes cumbersome.

Is there a way to perform this dynamically.

Thanks
Mark

It is fixed.

Hello,

can anyone please suggest me how do I create output files with multiple record types using px

Thanks
Mark

thank you

Thank You. I have 1 more question; If the user do not explicitly use those commit parameters in his job and for eg; if the job aborted or hangs up say after deleting 100 records due to some oracle connectivity issues, in such a scenario would those 100 records be commited in the oracle table in the ...

Hi all, I have a delete sql statement in my oracle enterprise edition stage. I also want to "commit" the delete on the SQl table after the execution of delete statement from oracle enterprise edition stage. Can anyone please suggest me if I have to explicitly declare commit or does data st...

Hi All, Can anyone please advice me for the following problem. I have to capture all "ID_B" occuring more than once in the input file Input File: ID_A ID_B 520 41 522 31 523 61 524 61 525 31 526 31 527 21 Output file: ID_A ID_B 520 41 527 21 Reject file: ID_A ID_B 523 61 524 61 522 31 525 ...

[quote="filename.txt"]Take logic like this,... in transformer define a stage variable if prevrow_dept=current_dept then stgvar1=stgvar1+1 else stgvar1=0 in columns give the below expression.. if stgvar1>inrow.limit then inrow.student else setnull() --for outrow.student and put output const...

I sorted the data based on department + student and added this logic. i was not sure the initial value for prevrow_student. i assigned the prevrow_student as current_student. it did not give me my desired output.

Please advice me.

Thanks
Mark