Search found 5 matches
- 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...
- 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
- 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
112A
112B
112C
My output should be Max(Column) i.e 112C
- 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
- 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