Search found 42189 matches

by chulett
Mon Jul 31, 2006 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange Date problem
Replies: 10
Views: 2141

This problem sounds familiar. I believe if you search you'll find at least one other mention of this - and that it is a known bug. :?
by chulett
Sun Jul 30, 2006 11:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migrating ds jobs from 7.1 to 7.5
Replies: 7
Views: 1216

Meena, I know you do or you wouldn't be using the MCM. I was spelling it out for Champa's benefit. :wink:
by chulett
Sun Jul 30, 2006 11:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email sending Error using DSSendMail
Replies: 5
Views: 3527

Re: Email sending Error using DSSendMail

Note:: These settings works OK for windows Outlook Doesn't matter. Your UNIX server is doing the mail sending here, not Windows nor Outlook. I'd suggest you talk to your SAs. Let them know what you are doing and what errors you are getting. Getting email to send out successfully from that AIX box f...
by chulett
Sun Jul 30, 2006 7:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: one row generates several rows
Replies: 6
Views: 1931

With a known, fixed maximum number of records to generate from each input record that isn't "too big", you could always just use that many output links with optional constraints. In your case, that means four. Each one building a record and constrained to only send the result out if the max is not ...
by chulett
Sun Jul 30, 2006 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: one row generates several rows
Replies: 6
Views: 1931

It's all about writing out what looks like one record to DataStage that is actually several as far as the operating system is concerned when read back in. You do this by including record terminators inside the one record, terminators that work for your O/S - either <LF> for UNIX or <CR><LF> pairs fo...
by chulett
Sun Jul 30, 2006 7:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migrating ds jobs from 7.1 to 7.5
Replies: 7
Views: 1216

If you have both versions of the Server installed, then yes, that is one way to do the upgrade. However, if you want to upgrade your existing 7.1 Server to 7.5 you can do that directly. Meaning, simply upgrade the 7.1 Server to 7.5 by applying the 7.5 version directly to it. It will automatically up...
by chulett
Sat Jul 29, 2006 2:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Duplicate Records
Replies: 30
Views: 13034

And whaddaya know, a link to a Tech Tip at the top of the page that explains exactly how to do that! :shock:
by chulett
Sat Jul 29, 2006 7:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Input Value Change
Replies: 8
Views: 2175

Ah... a little late I see, too long spent polishing the vowels. Still something to consider or to take note of in the future.
by chulett
Sat Jul 29, 2006 7:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Input Value Change
Replies: 8
Views: 2175

Re: Input Value Change

Can anyone tell me how to detect whether a particular input column in a transformer has changed to a new value or not? The simple answer to this is sure - with stage variables. However, the devil is in the details. Is your input data sorted? Once you've found your 'first A' will all the rest of the...
by chulett
Sat Jul 29, 2006 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Seq.file to table
Replies: 8
Views: 3628

that means in each run datastage may not read in sequence i.e say for example @INROWNUM= 100 for 100th record may not be same in second run @INROWNUM = 100 for 100th record could be 200th record.Datastage reading sequential records not in sequence even though its processing all records. Edward, it'...
by chulett
Sat Jul 29, 2006 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Duplicate Records
Replies: 30
Views: 13034

I was wrong about the 'sid' stuff. As Kim has noted several times, it's because of a lack of the 'www' in front of the domain name in the link. Copy the shortcut and paste it in your address bar, add the www and then go. Or click here. It's just one of the plethora of posts on the subject of Duplica...
by chulett
Fri Jul 28, 2006 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: lookup with value and range value
Replies: 7
Views: 1293

Is there a database involved anywhere here? You could easily construct a table holding range name, low value and high value and then join to this on the way out using 'between' logic...
by chulett
Fri Jul 28, 2006 11:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IMPORT Read Only DSX file
Replies: 5
Views: 3954

Cool. :D
by chulett
Fri Jul 28, 2006 11:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IMPORT Read Only DSX file
Replies: 5
Views: 3954

How large is 'large'? Editors like UltraEdit32 can handle very large files and on UNIX you have functions like 'sed' to do that. Very little pain involved in either of those. :wink: