Search found 5 matches

by sriram_bcl
Mon Feb 04, 2013 11:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert,update,insert/update on same table in same job
Replies: 5
Views: 3912

Insert,update,insert/update on same table in same job

I have one job where in Server edition doing four operations on same table in same job i.e insert,update,insert/update,update with four different links with different filter conditions. To implement same logic in PX, I am not able to do. I am getting unique constraint violation error. Please suggest...
by sriram_bcl
Mon Dec 31, 2012 3:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding Max and Min on varchar column
Replies: 9
Views: 8206

This problem persist in existing project. Combination of Sort and Remove duplicate did not work. We tried long time back but did not work.
by sriram_bcl
Mon Dec 31, 2012 3:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding Max and Min on varchar column
Replies: 9
Views: 8206

Re: Finding Max and Min on varchar column

My iniput column contains
112A
112B
112C

My output should be Max(Column) i.e 112C
by sriram_bcl
Mon Dec 31, 2012 1:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding Max and Min on varchar column
Replies: 9
Views: 8206

Re: Finding Max and Min on varchar column

Thanks for the reply. I tried all the possibilities with Agg. We have incoming data contains like 'abcdefg' etc. we are facing issue in finding min and max on string. In server job using aggregator we are able to do. in PX i am not able to do it. Plz suggest
by sriram_bcl
Mon Dec 31, 2012 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding Max and Min on varchar column
Replies: 9
Views: 8206

Finding Max and Min on varchar column

Can any one suggest how to find Maximum and Minimum on varchar column in Datastage 8.1