DSXchange

This issue is resolved and I used the calculation of
((Monthnumber-1)/3)+1 to find the quarter and assigned to an integer variable.


Thanks Craig. Thanks Ray.

Let me try this option ( (Monthnum -1)/3) +1 and will post the result

Hi Craig,

It is coming correctly if the month number is 11 and if the month number is 6 or 12 , the output is coming wrongly

Yes, Craig. It is for Calendar year.

I am able to find the quarter using the MOD function.

Thanks a lot.

Hi,

I need to find the quarter from the input date '2010-02-01' . The output should be 1 ( which implies the input date falls in 1st quarter)

In server editon, we have Built in-date transform routine like 'QUARTER.TAG . I am unable to find one in PX.

Please let me know.

The problem is resolved. I did like this, Before -job subroutine -------------------------- cat #sct_eswm_mig.$PROJECT_PATH#/#sct_eswm_mig.$OUTPUT_DIR#/#OUTPUT_FILE# > #sct_eswm_mig.$PROJECT_PATH#/#sct_eswm_mig.$STAGE_DIR#/#GLCOMP_FILE#.tmp after job subroutine ------------------------ mv #sct_eswm_...

Thank you all, for your responses. I can understand chulett and Ray's solution. Let me explain the scenario. For eg- If a Job X is creating 3 different files FILE1,FILE2,FILE3 then in the job properties of Job X, in after sub routine - EXECSH- I can use the command of cat FILE1 FILE2 FILE3 > FILE4 B...

If the single input file is producing 3 different output files, I can concatenate using cat command in after job subroutine. But these files are produced using 3 different input files.

Should I use a 'link collector' to combine the 3 files and then use after job subroutine? Please advise.

I have generated 3 output sequential files from 3 different input files. All the output files has column headings and values separated by '|' Symbol OUTPUT FILE1 NAME- FN23_1a.dat ====================== GLORDDER|COMPVALUE|COMPTEXT|ORGID|SID 1|1111|ANZ|X601|1 1|1112|ANE|X601|2 1|1113|ANB|X601|3 1|111...

As mentioned by you, this problem got resolved when gave the command in Job Properties-Input value mv #sct_eswm_mig.$PROJECT_PATH#/#sct_eswm_mig.$OUTPUT_DIR#/#OUTPUT_FILE#_#BATCH_NUM#.dat #sct_eswm_mig.$PROJECT_PATH#/#sct_eswm_mig.$OUTPUT_DIR#/#OUTPUT_FILE#_#BATCH_NUM#_`date +%Y%m%d`.dat for the aft...

I need to generate a file with filename of MAXIMO_GLACCOUNT_23_20090130.dat where MAXIMO_GLACCOUNT is a constant. 23- batch number 20090130-current system date when the file is generated( If I am generating the file tommorrow, it should be like MAXIMO_GLACCOUNT_23_20090131.dat .dat - constant I have...

Thank you so much, Ray.

As you mentioned I used
Oconv(@DATE,"D-YMD[4,2,2]") : "-12.00.00.000000" and I got the correct output.

I am having a column by name 'changedate' where the current system date has to be populated in the format of 2009-01-14-12.00.00.000000 Where today's date is 14-01-2009 and 12.00.00.000000 should be appended to the system date. When I assign @DATE = changedate in transformer stage and generate a seq...

Thanks, Ray. I did as you said and it worked.

Sequencer of my job 'A" runs Validate, default, transform, look up and load job sequentially. When I check the status of the jobs in Datastage Director, for the first four jobs - the Status is Finished. But the Load job, in Director is in 'Running' status without coming to an end. I resetted th...