Search found 53125 matches

by ray.wurlod
Mon Jun 01, 2009 12:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log file error
Replies: 7
Views: 2104

This is a corrupted hashed file, which contains the log for job number 1043. You can search the forum for ways to get out of this situation, depending on how badly you need the contents of the log. The address in the backward link error suggests that your log hashed file has tried to exceed its limi...
by ray.wurlod
Sun May 31, 2009 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to implement rank system
Replies: 2
Views: 1140

Rank is a display function. Most query languages support it, as do most business intelligence tools. Rank is not something you ought to be asking an ETL tool to do.
by ray.wurlod
Sun May 31, 2009 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I can't run jobs on my home PC
Replies: 4
Views: 1916

It might also be that you do not own a legitimate licence.
by ray.wurlod
Sun May 31, 2009 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling in transformer
Replies: 19
Views: 8254

Ur was a city in ancient Babylon. The second person personal pronoun in English is spelled "your". Please maintain a professional standard of written English on DSXchange, which is used by many people whose first language is not English.
by ray.wurlod
Sat May 30, 2009 6:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.BCIPut call to OCONV failed
Replies: 9
Views: 4423

The character between Centre and Janakpuri is 0xA0 (Char(160)). Check your source data to determine whether this actually occurs there. And do check the NLS_LANG setting for Oracle.
by ray.wurlod
Sat May 30, 2009 3:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need sessions information
Replies: 1
Views: 947

Version 7 answer.

Each connected client creates a lock and a record in the DS_LICENSE hashed file. The key to the hashed file includes the MAC address of the client machine. Note, however, that this happens not only for Designer but also for Manager and Director client connnections.
by ray.wurlod
Sat May 30, 2009 3:19 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Need support information on datastage TX/mercator 6.7
Replies: 7
Views: 6788

No problem. But please note that I have no experience whatsoever with Mercator or TX.
by ray.wurlod
Fri May 29, 2009 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling in transformer
Replies: 19
Views: 8254

Trim() will not remove all blank spaces, it will leave one. You may need to re-think your logic. For example

Code: Select all

NullToEmpty(Trim(InLink.TheField)) <= " "
by ray.wurlod
Fri May 29, 2009 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to login in parallel project
Replies: 3
Views: 1125

What is different between the project(s) to which you can connect and the project(s) to which you can not connect? "Nothing" is not the correct answer. For example, is there an environment variable that occurs in the latter but not in the former?
by ray.wurlod
Fri May 29, 2009 4:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to login in parallel project
Replies: 3
Views: 1125

Welcome aboard. Every project, or just some? What about the project that was first created (when DataStage server was installed)? Can you connect to the server with the Administrator client?
by ray.wurlod
Fri May 29, 2009 4:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between DataStage7.5 and 8.2
Replies: 3
Views: 1270

Version 7.5 has been released to general availability.
Version 8.2 has not been released.
by ray.wurlod
Fri May 29, 2009 4:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fault Type 11
Replies: 7
Views: 2890

Fault type is signal number. Signal number 11 is SIGSEGV (segmentation violation). Search.
by ray.wurlod
Fri May 29, 2009 4:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date conversion problem.
Replies: 2
Views: 919

Oconv(Iconv(InLink.TheDate, "DDMY"), "DYMD[4,2,2]":@VM:"MCN")