Search found 7 matches
- Fri Apr 06, 2012 3:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: maximum length of varchar Stage variable
- Replies: 4
- Views: 5927
maximum length of varchar Stage variable
Hi Everyone, I have a scenario wherein i am doing vertical to horizontal pivot. This requires concatenating field to itself 80 times. The field length is 2000.This means the stage variable which is going to hold this value should be of length 160079(2000*80 + 79(field delimiter)). Can someone confir...
- Thu Dec 08, 2011 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue when using 'Generate key from last highest value=NO'
- Replies: 7
- Views: 4415
- Wed Dec 07, 2011 8:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue when using 'Generate key from last highest value=NO'
- Replies: 7
- Views: 4415
No although contigous value is preferred it is not mandatory. Can you please let me know the maximum value generated by surrogate key generator using state file? In my project I am expecting huge volume of data.And this table will grow with each passing day. I am just wondering if I continue to lose...
- Wed Dec 07, 2011 2:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue when using 'Generate key from last highest value=NO'
- Replies: 7
- Views: 4415
issue when using 'Generate key from last highest value=NO'
Hi, I am facing some issue when using same surrogate key state file by separate jobs in parallel. 1.Currently I am using the stage in parallel mode with 'Generate key from last highest value=YES'. Beacuse of this as expected value generated will not be continuous. But this approach is desired becaus...
- Thu Nov 17, 2011 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate key - stat file
- Replies: 4
- Views: 3750
- Wed Nov 16, 2011 4:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate key - stat file
- Replies: 4
- Views: 3750
Surrogate key - stat file
How to read stat file (FileName.sk) which is generated in surrogate key stage?
- Thu Mar 24, 2011 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output File Generation
- Replies: 0
- Views: 1358
XML Output File Generation
Hi, I need to generate a xml file in the following format. Expected File: <Body><Profile><EmpId>123</EmpId><NameInfo><NameType>Legal</NameType><Name>Winster</Name><LastName>Ray</LastName></NameInfo><NameInfo><NameType>NickName</NameType><Name>Winster</Name><LastName>Ray</LastName></NameInfo></Profil...