DSXchange

bhasds

Hi Atul, The second job will be able to read the dataset created by the first job as the reading of dataset is not dependent on the configuration file of the current job but the copy of the configuration file exist in the control file or the descriptor file of the dataset you are trying to read. Bha...

bhasds

Hi HemaV, The scenario can be solved by using loop variable. In iteration- @ITERATION <= Len(Reference.col2) /2 Take 2 loop variables- Derivation LoopVariable If @ITERATION <=1 Then LV1 Else LV1 +2 LV1(initialize with 2) If @ITERATION <=1 Then LV2 Else LV2 +3 LV2(initialize with 3) Output Derivation...

bhasds

I think you can use orchadmin command in after job subroutine to get the value in ascii format in a file.
And then use that value as parameter in the required job.

Please let me know if it works.

bhasds

Hi Raji33,

You may try the below to get the first day of last month-

Code: Select all

CurrentDate()[1,4]:"-"If  CurrentDate()[6,2]-1 < 10 Then 0: CurrentDate()[6,2]-1 Else  CurrentDate()[6,2]-1):"-":"01

bhasds

Hi uzl,

You may use the following to get the 3 month back date-

Code: Select all

'01':"-":(if  DSJobStartTimestamp[6,2] - 3 <10 Then 0:DSJobStartTimestamp[6,2] - 3 Else DSJobStartTimestamp[6,2] - 3):"-":DSJobStartTimestamp[1,4]:'00:00:00'

bhasds

I am not sure why you are getting the error giving error .../bin/echo: write error: Broken pipe If this key column NAME1 NAME 2 LAST NAME NAME_TYPE 123 ABC DEF GHI P XYS XXX YYY A WWW BBB AA A is your desired output- Then the posted code will give you the output which can be read in separate columns...

bhasds

Please find the corrected code as below- In stage variable in transformer- If key column <> SV2 Then NAME1 :" ": NAME2 :" ": LAST NAME:" ":Left(NAME_TYPE,1) Else If Index(NAME_TYPE,"ALIAS",1)>0 Then SV1 :" ":NAME1 :" ":NAME2:" ":L...

bhasds

Hi pillip,

Could you please post some sample input records and the desired output.

bhasds

Hi ghutchin, You may try this in stage variable- If ME1 <> SV2 Then NAME1 :" ": NAME2 :" ": LAST Else If Index(NAME_TYPE,"ALIAS",1)>0 Then SV1 :" ":NAME1 :" ":NAME2:" ":LAST:" ": Left(NAME_TYPE,1) Else @FALSE---->SV1 ME1--->SV2

bhasds

@Ray- Could you please suggest how to generate this part ijkl(PDPI); in pivot enterprise stage. @bond88- You may try the below in transformer to get the desired output. 1.In stage variable- If ToT.Role <> SV3 Then "[":ID:"]" Else SV1:",": "[":ID:"]" ...

bhasds

Hi Craig,

I will try not to think field() function in every post and reading the records as single string.

bhasds

Hi prasson_ibm, I think the: field(in.col,",",1) in transformer output link should be- in.col[1,4]:",":field(in.col,",",5) link1 in.col[1,4]:",":field(in.col,",",6) link2 in.col[1,4]:",":field(in.col,",",7) link3 in.col[1,4]:"...

bhasds

Hi Deesh, You may try with a transformer and a pivot stage. 1.In transformer output derivation, 1,2,3,4 into a column and A,B,C,D in four different columns. 2. In pivot stage you can take the first column as key column(1,2,3,4) and pivot the 4 columns into a single column. Note- The above is possibl...

bhasds

If you are trying with loop you may try the below-

1.In stage variable-

Code: Select all

col1    SV1

2.Loop While -

Code: Select all

@iteration<=Dcount(SV1,",")-4

3.In loop variable derivation-

Code: Select all

Field(SV1,",",4+@iteration)  LV1

4.OUtput col deriavtion-

Code: Select all

Col1:",":LV1   Col1

bhasds

Hi qutesanju, For this in individual job? As Ray has posted ExecSh option is avalable in the afterjob subroutine of a individual datastage job. Choose ExecSh option and in input value- mv generatedfile generatedfile_`date +%Y%m%d%H%M%S` And Check the option- Only Run after-job subroutine on successf...

DSXchange

Search found 78 matches

Re: Dataset and Configuration File

how to pass dataset value as a parameter to next job

getting data for the last three months