Search found 3 matches

by Jones Sam
Wed Oct 23, 2013 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage
Replies: 5
Views: 1571

Hi Craig I tried with two stage variables. PreviousValue = CurrentValue CurrentValue = input.column if (CurrentValue < PreviousValue) then "" Here initially currentvalue does not hold any values then the column values are assigned to previousval stage variable to perform comparision. I tri...
by Jones Sam
Sun Oct 20, 2013 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage
Replies: 5
Views: 1571

Hi we can do this is server job with stage variable as below. stagevar1=RowProcGetPreviousValue(input.column) stagevar2=input.column if(stagevar2<stagevar1) then "yes increasing" else "no" I tried in parallel job using stage variable but not successful. Please share your thoughts...
by Jones Sam
Thu Oct 17, 2013 6:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage
Replies: 5
Views: 1571

Datastage

Hi All, I have file which has values in a column like below. col 100 250 300 500 I need to compare if row 1(100)> row 2(250) and row 2(250)> row 3(300)and row 3(300) > row 4 (500),, Basically I am trying to find if the next row value in a column is greater than the current row value of the same colu...