Search found 42189 matches

by chulett
Thu Jun 07, 2012 6:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Will partition despite the preserve-partitioning flag issue
Replies: 3
Views: 2508

And away we go... :wink:

Split into your own topic from this one.
by chulett
Thu Jun 07, 2012 6:00 pm
Forum: General
Topic: Execute Log
Replies: 3
Views: 1770

We'd need more information in order to help you properly. For example, what is your script doing to "pick up the ds execute log file" and some clarification around what "half the log file" means. Any idea where the issue lies? Is the entire log getting written to the file but it ...
by chulett
Thu Jun 07, 2012 8:18 am
Forum: General
Topic: the host is not responding (81011)
Replies: 6
Views: 7195

Not a lot of information to work with. How isolated is this issue, i.e. can others connect successfully and the issue is just with your installation? As a wild stab I'm wondering if you have a firewall issue, if the required set of ports are enabled / opened that the product needs, which are all doc...
by chulett
Thu Jun 07, 2012 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 sequence implementation in datastage
Replies: 3
Views: 2671

If what you need is to run the job multiple times for a range of parameter values, a Sequence job with the Loop stages should work. You'd have to either build a delimited list of those values or from a starting point compute the next value for a set number of iterations.
by chulett
Thu Jun 07, 2012 8:04 am
Forum: General
Topic: E-mail Notification - Report in the Body of the mail
Replies: 2
Views: 1361

It's been discussed a number of times here. To get it in the body you need to "roll your own" routine to send mail with a variable body. You could start with DSSendMail and tweak it, or start from scratch.
by chulett
Thu Jun 07, 2012 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check zeros in transformer Stage
Replies: 6
Views: 1926

Kind of crazy that the functions are actually documented somewhere. :wink:

You'd also have this information in the pdf manuals delivered with the product and in the "online" help as well.
by chulett
Thu Jun 07, 2012 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consumed more than 100000 bytes looking for record delimite
Replies: 9
Views: 3759

You need to determine what the details of your file are so you can read it properly. A hex editor can help or perhaps "od -h" or some other flavor of a dump so you can see the actual hex/octal/decimal values.
by chulett
Thu Jun 07, 2012 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ABAP Parameter Passing Error
Replies: 2
Views: 1772

Cool, thanks for posting your solution Colin. :wink:
by chulett
Thu Jun 07, 2012 7:24 am
Forum: General
Topic: Reading Datastage logs from Unix
Replies: 5
Views: 3278

That's because you are sitting in the bin directory.

3) cd to a Project directory
4) fully path the call to dssh/uvsh
by chulett
Thu Jun 07, 2012 7:20 am
Forum: General
Topic: the host is not responding (81011)
Replies: 6
Views: 7195

Want to double-check - the information you posted is for the client or the server? If it is from the client machine, can you post details of your server architecture?
by chulett
Wed Jun 06, 2012 9:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consumed more than 100000 bytes looking for record delimite
Replies: 9
Views: 3759

... if so then the answer to my question would be "1". :wink:
by chulett
Wed Jun 06, 2012 8:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consumed more than 100000 bytes looking for record delimite
Replies: 9
Views: 3759

If you used 'UNIX newline' and it couldn't find it, then that's not your record delimiter. What does a "wc -l" on your filename return?
by chulett
Wed Jun 06, 2012 6:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01722: invalid number
Replies: 17
Views: 12757

:wink:
by chulett
Wed Jun 06, 2012 6:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Consumed more than 100000 bytes looking for record delimite
Replies: 9
Views: 3759

What is your record delimiter? You did not mention that and that is what it is saying that it could not find.
by chulett
Wed Jun 06, 2012 12:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to find reject records
Replies: 1
Views: 756

Sorry but what exactly do you mean by "how to find error record table records"? I'm wondering what the answer might be other than "look in the error table"... :?

Can you be more specific?