Search found 504 matches

by ShaneMuir
Thu Oct 28, 2004 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File update based on field list
Replies: 4
Views: 2024

Thanks for all your input guys it is most appreciated. :!: Thanks for the code Ray, it probably would work (after all its you :wink: ) for what i need - but the focus here was on simple. I was hoping to acheive it using standard stages and not coding. My original thoughts were along the lines of Kim...
by ShaneMuir
Wed Oct 27, 2004 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File update based on field list
Replies: 4
Views: 2024

Sequential File update based on field list

Hi again to everybody in DSXchange land, Is it possible to 'filter' which fields are written to a sequential file output based on a list which contains the field names? What I currently have is a job which creates a sequential output containing some 163 fields which is written to a fixed width file....
by ShaneMuir
Fri Oct 22, 2004 1:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mutex errors
Replies: 12
Views: 6669

Hi again In response the the link collector with 17 different inputs, i suppose i should have mentioned that each stream although different is then transformed into a single concatenated text field so that they are the same length and can be fed into a link collector, before being sent to a single t...
by ShaneMuir
Thu Oct 21, 2004 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mutex errors
Replies: 12
Views: 6669

Hi again everyone Just to let you know, we still haven't found the cause of the problem, but as it turns out, it was not an isolated problem, another part of the project on a separate site also had the same problem, so at present we have just migrated only the job executable to production and it wor...
by ShaneMuir
Wed Oct 20, 2004 2:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mutex errors
Replies: 12
Views: 6669

Craig: In answer to your question, the operating system is HP-UX 11i and the timeout was originally set at 10 secs and i moved it up to 300 secs. The thing is that the time out errors occur after about 6 seconds anyway. Vincent: Unfortunately I don't think the Pivot table will work as each of the ou...
by ShaneMuir
Tue Oct 19, 2004 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mutex errors
Replies: 12
Views: 6669

Thanks for the quick response there Craig, In response to your questions 1. What kind of things am i doing in the job - its all very simple (or at least i thought it was). a. Flat file comes in b. Transform ads a couple of extra fields based on input data c. Rather large transform - 3 hash files whi...
by ShaneMuir
Tue Oct 19, 2004 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Mutex errors
Replies: 12
Views: 6669

Mutex errors

Hello everybody, I have searched around the forums to find information about 'timeout waiting for mutex' and have found some useful information but nothing which clears up my problem which is as follows: I am running a very simple job from a flat file which uses a couple of hash file lookups - when ...
by ShaneMuir
Thu Aug 05, 2004 3:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stripping Non Printing Characters
Replies: 5
Views: 3018

Thanks for that guys. Most appreciated.

Shane

PS: Yes Ray I am a long way from Brisbane :D
by ShaneMuir
Wed Aug 04, 2004 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stripping Non Printing Characters
Replies: 5
Views: 3018

Stripping Non Printing Characters

Hi everybody I am sure this is quite an easy one for all of you but here goes anyway: I wish to strip all the non printing characters from an input string. I am aware of the routine Oconv(expression, MCP) but I do not wish to replace the offending character with a period, rather a character of my ch...