Search found 497 matches
- Tue Oct 04, 2011 11:53 am
- Forum: General
- Topic: Parameter Set - Assigning Values as Runtime via script
- Replies: 5
- Views: 3677
Re: Parameter Set - Assigning Values as Runtime via script
How are you assigning the values to the parametr set, PS work differently. Th values are alreday defined and one needs to pass the value file name in the script when calling the parameter set.
- Wed Jun 29, 2011 2:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Stage Warning.
- Replies: 24
- Views: 14101
- Mon Jan 17, 2011 5:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job warnings
- Replies: 9
- Views: 6470
- Thu Jan 13, 2011 3:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job warnings
- Replies: 9
- Views: 6470
- Thu Jan 13, 2011 11:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job warnings
- Replies: 9
- Views: 6470
- Tue Jan 11, 2011 9:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job warnings
- Replies: 9
- Views: 6470
By now (491 posts) you should realize that we need exact error messages. Without these we're wasting time guessing. Oh, and disable operator combination before capturing the error messages, so that ... The warning messages are :- Sort key <key name> no longer exists in the dataset schema. It will b...
- Wed Jan 05, 2011 9:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job warnings
- Replies: 9
- Views: 6470
Job warnings
Hi All, I am getting warnings like sort key no longer exists and it will be dropped from the inserted sort merge collector. This warnings are generated for all the sort keys. The design of the job is there is an input link, data is sorted and hash partitioned in the sort stage, then same partitioned...
- Tue Sep 21, 2010 2:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163
- Thu Sep 16, 2010 3:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163
How do you intend to use this file in the downstream process ? In the place you read the file, mention record delimiter as 'none' and work with the plan that there is an extra comma. No need to worry about it. I have tried all the different options while reading the file in the next job, but it alw...
- Thu Sep 16, 2010 3:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163
- Wed Sep 15, 2010 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163
Isn't that what you asked for ? Trim the trailing comma. When I am trying to read that file in a separate job where I can trim that trailing comma, i am able to trim the last comma and getting the desired output but the job throws warning like Missing Record delimiter '''', saw EOF instead, and mor...
- Wed Sep 15, 2010 7:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163
- Wed Sep 15, 2010 7:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maltiple instances of jobs
- Replies: 2
- Views: 2193
Re: Maltiple instances of jobs
First thing you need to do is make the job sequence as multiple instance one, that you can set from the Job property and then you can run as many instances as you want, but the invocation id passed shld be separate for separate sequences.
- Tue Sep 14, 2010 6:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163
- Fri Sep 10, 2010 9:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row comma separated values
- Replies: 29
- Views: 25163