DSXchange

Hi All,

If we are calling 3 jobs in a sequence, can we get the start time and end time of all the 3 jobs using DS commands from the sequence??? Please help me...

Thank You For Your Reply...I tried as follows... [b]APT_String date_out4[8],temp[8]; temp[1]=year1; temp[2]=month1; temp[3]=day1; outdata1.date_out4=temp;[/b] I got the error as follows.. Operator Generation Failed buildop -f -BC /auto/opt/Studio8/SUNWspro/bin/CC -BL /auto/opt/Studio8/SUNWspro/bin/C...

outdata1 only..

outdata1.date_out4[1]=year1;
outdata1.date_out4[2]=month1;
outdata1.date_out4[3]=day1;

APT_String date_out4[8];
char year1,month1,day1;

outdata1.date_out4[1]=year1;
outdata1.date_out4[2]=month1;
outdata1.date_out4[3]=day1;

Hi All, I have created a BuildOp stage which needs to return an array value. I need to return the value in date_out4 via the output interface outdata1. How can we return an array from BuildOp to datastage. What datatype we need to mention in datastage for date_out4? I tried like below, APT_String da...

Thanks for your reply Craig. It gets resolved now. I changed input and output port to indata and outdata. Its working now.

Hi, I am trying to create a new build parallel stage for dividing two numbers. I have given input port as 'in' and output port as 'out'. The input table definition is two columns 'a' and 'b' and output table definition is one column 'c'. In Per_Record tab, I have given the code as out.c=in.a/in.b; W...

Hope Unicode would have been set in the database stage for that chinese column. Can you try by removing that unicode(if set) and providing length as triple the size of the original length.

Do full outer join on AAAA.txt and BBBB.txt. You will get left link key columns and right link key columns that is AAAA.key columns and BBBB.key columns. Next in a transformer stage take two output links, One link contrained with AAAA.key columns as null(i.e Records in BBBB is not in AAAA) and anoth...

Use Aggregator stage with key columns as 2nd, 3rd and 4th column and get maximum value of the 1st column

Hi All, I need a help for the following logic for working with Restructure stages... My input is col1,col2,col3 1,A,12 1,B,13 1,C,14 2,D,15 In the Combine Records stage, I have keycolumn as col1 and subrecordoutputcolumn as subrec. I have set RunTimeColumn Propagation also. Am getting the output in ...

If the records come in same order, then you can use a stage variable stgvar in transformer and reset the stage variable stgvar to zero if col2='x' else if col2='D' add col3 to stgvar, else if col2<>'D' or 'x' add zero to stgvar.

Will the records come in same order???

Sort the records based on col1 and col3 and generate keychange column. And then in next transformer use a stage variable stgvar. Reset the stage variable to 0 if keychange column is 1, else increment the stage variable. And then pass records only with key change column=0