Search found 42189 matches

by chulett
Sun Mar 05, 2006 11:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can server container be used in parallel job
Replies: 4
Views: 1104

More to the question than just 'can I'. Read the section in the Parallel Job Developer's Guide on Incorporating Server Job Functionality. It's page 2-33 in my copy and gives details and caveats of using them in a PX job.
by chulett
Sun Mar 05, 2006 8:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Locked job not released
Replies: 6
Views: 1639

sgiang wrote:How can I set it such that my client session will not time-out ? I can't seem to be able to find it in Administrator.

It's there, right on the front from what I recall, but you need to be 'dsadm' to change it. Next to the timeout value is a checkbox to 'Never timeout'.
by chulett
Sun Mar 05, 2006 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Server Restart
Replies: 8
Views: 3300

It's not always possible to clear all users and you may not personally have the permissions that you need to do so. In that case, stop the server which will kill the connection... eventually. In most cases. I've had to do that many times for various and sundry reasons. Once the server is down, start...
by chulett
Sat Mar 04, 2006 10:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: substring
Replies: 7
Views: 2345

Ah. Thanks for the clarification, Mr Ray. :D
by chulett
Sat Mar 04, 2006 11:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading a record from Tab delimited sequential file
Replies: 5
Views: 1288

You may also find that manually editing the file helps tremendously. :wink:
by chulett
Sat Mar 04, 2006 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: substring
Replies: 7
Views: 2345

Sunshine, just an FYI. If you wanted to go crazy you could shorten that all down to one expression: Substrings(Input.Sentence,Index(Input.Sentence,ExtractWord,1),Len(ExtractWord)) I'm sure you broke it up to illustrate the individual steps, but also wanted to point out it cou...
by chulett
Sat Mar 04, 2006 8:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: substring
Replies: 7
Views: 2345

Re: substring

I would like to extract specific substring from string, without knowing the position of that substring. That particular substring position is not fixed, it can be any where in the String. Technically, you will have to know or determine the position of the substring if you truly want to extract it. ...
by chulett
Sat Mar 04, 2006 8:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL errors while running batch schedule
Replies: 13
Views: 8681

In other words, have a chat with an SA. :wink:
by chulett
Sat Mar 04, 2006 12:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading a record from Tab delimited sequential file
Replies: 5
Views: 1288

That doesn't seem to be a 'tab delimited' read problem - are you saying that your file is messed up and there is a CR in the middle of record 3? :?
by chulett
Fri Mar 03, 2006 2:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: patch file
Replies: 2
Views: 1925

The patch is non 'version specific' and is related to Windows SP2.
by chulett
Fri Mar 03, 2006 2:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CRC32 Does have limitations (severe in my opinion)
Replies: 26
Views: 12659

Pad them (each field) to a consistant size.
by chulett
Fri Mar 03, 2006 1:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CRC32 Does have limitations (severe in my opinion)
Replies: 26
Views: 12659

Actually, try it without the commas between the fields. Don't understand exactly why, but with commas = same checksum while without commas = totally different checksums.
by chulett
Fri Mar 03, 2006 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Please post clear and descriptive topics
Replies: 3
Views: 12990

We need to use a bit of thought before submitting 'corrective' posts. This will make DSXChange a more positive environment for everyone. I concur. IMHO, people have gone a little overboard with feeling a need to correct others posts. People will 'inappropriately' quote entire messages for no reason...