Search found 15603 matches

by ArndW
Wed Dec 26, 2007 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fmt FROM SERVER TO PARALLEL
Replies: 17
Views: 3270

What data types are your input and output columns?
by ArndW
Wed Dec 26, 2007 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to increase the performance of Parallel jobs
Replies: 10
Views: 2953

Using that method might lead to someone writing a learned document about performance enhancement, something like Asimov's "The Endochronic Properties of Resublimated Thiotimoline" But back to the oringal poster's question: The subject of performance tuning is large enough to have had many books writ...
by ArndW
Wed Dec 26, 2007 6:23 am
Forum: Site/Forum
Topic: Duplicate Posts
Replies: 22
Views: 9977

This is becoming more of an issue over time. Not only are the duplicate posts proliferating, but much of the time when I post replies I get timeouts as well and since I'm logging in from different systems the cause must lie in the DSXchange site itself. Are others seeing this issue as well?
by ArndW
Wed Dec 26, 2007 6:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get full length warning messages in attachment
Replies: 9
Views: 2298

The reason is DSGetLogSummary() which is only returning the first portion of the message. You need to get the EventId from the summary array, then use the DSGetLogEntry() function to get the full message.


p.s. It helps if you put code tags around your code to make it more legible.
by ArndW
Wed Dec 26, 2007 6:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fmt FROM SERVER TO PARALLEL
Replies: 17
Views: 3270

I give up. I posted the solution in my first reply. Perhaps someone else can post another one which will satisfy Suresh. (Addendum) I think that I now understand, my original post is "Premium Content" and that part of the reply might not be visible to Suresh. The solution I proposed involves looking...
by ArndW
Wed Dec 26, 2007 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fmt FROM SERVER TO PARALLEL
Replies: 17
Views: 3270

Suresh, the FMT function does not exist in parallel jobs; so you cannot just use the same logic. The function I suggested does the same thing as the FMT() but if you don't wish to use it then that is up to you. What you are trying to do is somewhat like converting a PASCAL program to C++ and having ...
by ArndW
Wed Dec 26, 2007 5:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to increase the performance of Parallel jobs
Replies: 10
Views: 2953

ray.wurlod wrote:...Set the system clock back while the job is running...

I'm going to have to add that method to my bag of performance tuning tricks!
by ArndW
Wed Dec 26, 2007 5:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting the error while reading the XML input file
Replies: 4
Views: 1125

Venki - as your question doesn't relate to this thread, you should post it as a new one in order to get an answer.
by ArndW
Wed Dec 26, 2007 5:40 am
Forum: General
Topic: Deleting header of Data file In UNIX
Replies: 7
Views: 1903

What "sed" command did you use? If you use a line-oriented command in sed it will not recognize ^L as a line break. Perhaps you could do 2 actions or 2 passes - replace your form feed with a normal line break then remove the headers.
by ArndW
Wed Dec 26, 2007 5:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FMT function logic in PX
Replies: 3
Views: 1474

Code: Select all

INT(ABS(Quantity)*New_Price_Per_Share) 
should offer the same functionality.
by ArndW
Wed Dec 26, 2007 5:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get full length warning messages in attachment
Replies: 9
Views: 2298

It seems that the truncation occurred in your program that gets the log entries into a file. How did you do that? Once that is known a solution might become apparent.
by ArndW
Wed Dec 26, 2007 5:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fmt FROM SERVER TO PARALLEL
Replies: 17
Views: 3270

As you've seen, the FMT function does not exist in Parallel jobs unless you choose to use a BASIC transform stage; but that is not recommended. In your case you wish to format the number with leading zeroes to 9 places. You can do this simply by RIGHT('000000000':LINK1.TEST,9) assuming your ...
by ArndW
Mon Dec 24, 2007 12:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation
Replies: 22
Views: 7290

Access rights - are you installing as the system administrator? Can you install MKS tookit separately with the same userid?
by ArndW
Mon Dec 24, 2007 10:47 am
Forum: General
Topic: Multiple instance of a sequence
Replies: 6
Views: 1797

I memorized that in grade school so I could show up those people who were spouting "antidisestablishmentarianism" :shock:
by ArndW
Mon Dec 24, 2007 10:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation
Replies: 22
Views: 7290

Well - what are you doing about it? The manual doesn't say that you cannot install MKS seperately so you could try that. What error occurs during the installation - perhaps access rights or space or even a 3rd party product (have you disabled the antivirus as suggested?).