Search found 42189 matches

by chulett
Mon Oct 13, 2008 10:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS FUNCTION
Replies: 2
Views: 789

You are going to have to answer that one yourself as it's not one that ships with the product but rather one written "in house". As in your house.
by chulett
Mon Oct 13, 2008 10:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML - Zero output count
Replies: 5
Views: 1454

Do what you are doing, but in the after job routine check the Transformer and the link that writes to the Sequential stage rather than the XML stage.
by chulett
Mon Oct 13, 2008 10:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge stage not opening
Replies: 5
Views: 1415

Have you used 'regedit' before? If not, you may want to have someone who has help you. Search for all entries of "Ascential", those are the ones that are your delete candidates in the registry.
by chulett
Mon Oct 13, 2008 10:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML - Zero output count
Replies: 5
Views: 1454

Re: XML - Zero output count

Someone told me that, this method will impact the perfomance of the job. To work my idea the perfomance statistics should be always on or something liek that. No & No. There's no "performance impact" to checking a link count after job, if that is what you mean by "this method". And you don't ne...
by chulett
Mon Oct 13, 2008 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datatype conversion
Replies: 1
Views: 952

Which macro, exactly? There isn't one called "Datetimestamp".
by chulett
Mon Oct 13, 2008 7:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-12519: TNS:no appropriate service handler found
Replies: 6
Views: 2494

:? That error has nothing to do with volume - either you can connect or you can't. Is there any "From previous run..." log message after you reset the aborted job?
by chulett
Mon Oct 13, 2008 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to pass DSProjectName macro as a parameter to Before jo
Replies: 8
Views: 2368

Have you tried what you posted? Macros stand alone in some areas and in others need to be wrapped in hash/pound signs. If that didn't work, try #DSProjectName# instead.
by chulett
Mon Oct 13, 2008 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine hangs
Replies: 13
Views: 3609

Why not put "c:\temp" as the filename and "dir -b" as the filter? Does that not work?
by chulett
Mon Oct 13, 2008 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-12519: TNS:no appropriate service handler found
Replies: 6
Views: 2494

Is this your first attempt at accessing Oracle in your jobs? Or first time for this instance? Something else? :?
by chulett
Mon Oct 13, 2008 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: A loop sequence can abort because too many checkpoints
Replies: 5
Views: 1883

I've seen something similar, but the problem number was smaller and the error was a 'stack overflow' due to the number of iterations. Got a client side patch for it from IBM.
by chulett
Mon Oct 13, 2008 7:30 am
Forum: General
Topic: Migrating DataStage resources...a sort of poll
Replies: 20
Views: 6344

The administrator user (typically dsadm) can compile in a Protected project using the Multiple Job Compiler.
by chulett
Sun Oct 12, 2008 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine hangs
Replies: 13
Views: 3609

That 'trick' should also work on Windows as long as you use the Windows NUL rather than the UNIX /dev/null equivalent, I would think. There's also a command line 'manual' out there, probably at the main site but also found here: m This is for the command line switches but there's a link back to the ...
by chulett
Sat Oct 11, 2008 7:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine hangs
Replies: 13
Views: 3609

There's always WinZip. Once you register it, from what I recall you can also download a command line interface for it. And I'd be shocked if the granddaddy of them all, pkzip, isn't still around.
by chulett
Sat Oct 11, 2008 12:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date type conversion
Replies: 5
Views: 1150

For Oracle you don't "need" any particular format, so long as the TO_DATE() mask matches your data.
by chulett
Sat Oct 11, 2008 8:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine hangs
Replies: 13
Views: 3609

Meaning, it has stopped and is waiting for someone to say yes or no. :wink: