Search found 42189 matches

by chulett
Fri Apr 28, 2006 12:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Substring problem
Replies: 12
Views: 3095

Count the number of separators and then dynamically use that to extract the 'last' FIELD. I've done this many times with a single separator character, having '\\' as one should be possible. At worst case, count the number of them and divide by 2. :wink:
by chulett
Fri Apr 28, 2006 9:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ascential Local folder increasing
Replies: 11
Views: 2723

DSguru2B wrote:Using the Clear.File option would it be the same as deleting the file.

Umm.. no. Do the CLEAR.FILE and then re-establish the auto-purge settings.
by chulett
Fri Apr 28, 2006 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue
Replies: 2
Views: 890

IMHO, you've listed them from least to most desirable.
by chulett
Fri Apr 28, 2006 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsenv file equivalent
Replies: 3
Views: 1088

'Some one' needs to be punished. :wink:
by chulett
Fri Apr 28, 2006 7:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job is Compiled, but Failed to Start
Replies: 9
Views: 2453

If you reset the job after it aborts, is there an entry in the log labelled 'From previous run...'?
by chulett
Fri Apr 28, 2006 7:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_loadlibrary: Win32 error in LoadLibrary of dsstp.so
Replies: 4
Views: 1506

There were some significant changes in that stage between 7.5 and 7.5.1A from what I recall. Perhaps you should take one of the offending jobs, remove the stage from it and rebuild it with the 7.5 version of the stage. Perhaps that will help. Always a little dangerous to go 'backwards' in versions.
by chulett
Fri Apr 28, 2006 6:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Event: PRINTER memory segment removed (...)
Replies: 5
Views: 3033

:? Interesting... 'they' specifically state in the readme that they will no longer log this. I'd suggest two things: report it to your support provider and search the forum as it has been discussed many times. I believe that Ray even posted the cause, but don't recall off the top of my head.
by chulett
Thu Apr 27, 2006 5:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join 2 tables on a key without using lookup
Replies: 12
Views: 2438

Yes sir. That would be correct, sir.
by chulett
Thu Apr 27, 2006 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join 2 tables on a key without using lookup
Replies: 12
Views: 2438

Yes, sorry... forgot not all peoples live on Planet Ellison. :cry:
by chulett
Thu Apr 27, 2006 2:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: opening unix file in extend mode
Replies: 2
Views: 1465

You mean 'append' mode. Search for the SEEK command.
by chulett
Thu Apr 27, 2006 1:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: reject link order
Replies: 9
Views: 1931

That's odd as that is the situation where it is supposed to matter where the reject row link is in the output link order. :?
by chulett
Thu Apr 27, 2006 12:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: reject link order
Replies: 9
Views: 1931

The answer will depend on if just the Reject Row check box is checked, there is an expression in the Constraint derivation - or both.
by chulett
Thu Apr 27, 2006 10:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row by row processing in datastage
Replies: 14
Views: 7406

If you have version 7.5.x then - Sequence job: Start Loop, End Loop and UserVariables Activity stages will get you what you need.
by chulett
Thu Apr 27, 2006 10:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to handle SYS.XMLTYPE fields
Replies: 5
Views: 1624

Search, my pastey friend, search! :wink:

See if either this post or this post helps.
by chulett
Thu Apr 27, 2006 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Infinite Number of Sort Stages
Replies: 6
Views: 1327

Have you tried just reinstalling the client?