Search found 42189 matches

by chulett
Wed Dec 08, 2010 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHESTRATE Exception
Replies: 9
Views: 9401

Uninstall the patch. Report the problem back to IBM.
by chulett
Wed Dec 08, 2010 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Anonymise data through DataStage
Replies: 2
Views: 1304

We've had various conversations here on the topic and it really depends on what you mean by 'anonymise', probably 'masking' as Ray notes. For example, one such conversation is here.
by chulett
Wed Dec 08, 2010 8:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: If the input column is in the last four months then X then Y
Replies: 4
Views: 1500

It means the first 7 characters from the output of the DSJobStartTimestamp macro, which is a constant that is the date/time that the job started.
by chulett
Wed Dec 08, 2010 7:59 am
Forum: General
Topic: DS Job list along with its last rundate
Replies: 3
Views: 1498

"dsjob -jobinfo" is (basically) the command. In a loop, call it for each of the jobs that you pulled from the project using "-ljobs". The output of the jobinfo call will include the last run date and status, from what I recall.
by chulett
Wed Dec 08, 2010 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set preloaded statement in target table?
Replies: 3
Views: 1471

Two ODBC links, one for the delete and one for the inserts. Make sure only the first row goes to the delete link before it goes to the insert link.
by chulett
Wed Dec 08, 2010 7:52 am
Forum: General
Topic: Datastage Scheduler stopped working
Replies: 10
Views: 2762

Not that I'm aware of, they (like all scheduled items) are only shown to the user that actually scheduled them.
by chulett
Tue Dec 07, 2010 7:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dssearch command
Replies: 3
Views: 3152

Does that work from the command line, i.e. outside of DataStage?
by chulett
Tue Dec 07, 2010 7:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Avoid Rouding Off in Parallel Job, 7.5.2 version
Replies: 3
Views: 2611

horserider wrote:$APT_DECIMAL_INTERM_ROUND_MODE = Round toward negative infinity
That doesn't look like any kind of valid APT value... perhaps "round_neg_inf"??? :?
by chulett
Tue Dec 07, 2010 7:17 pm
Forum: General
Topic: How to abort master sequnce if child sequnece aborts
Replies: 11
Views: 3256

Yes , I think restartability will work only if a sequence aborts not in other cases Correct. A Sequence job must have checkpoints enabled and have aborted to be in an Aborted/Restartable status which then means it can pick up from where it left off when you run it next. This regardless of it being ...
by chulett
Tue Dec 07, 2010 7:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routines to do
Replies: 8
Views: 2905

Could you take another shot at explaining what it is you are trying to do, please? I'm a little lost. Don't worry anything about "routines" or even any job / DataStage specific language, just lay out your requirements for us in words, much like they must have been given to you.
by chulett
Tue Dec 07, 2010 8:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PSV file has quote in the text body
Replies: 13
Views: 7335

... which means there are no 'extra' pipes in your file and thus my suggestion should have worked just fine as well.
by chulett
Tue Dec 07, 2010 8:15 am
Forum: General
Topic: Regarding batch script to zip and then delete the files
Replies: 3
Views: 1279

First you'll need some flavor of command line zip, which is not something that comes with Windows. MKS Toolkit, perhaps, but not Windows.
by chulett
Mon Dec 06, 2010 4:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC connection to Foxpro
Replies: 9
Views: 3803

Those "dbf" files are the database.
by chulett
Mon Dec 06, 2010 9:13 am
Forum: General
Topic: Datastage Scheduler stopped working
Replies: 10
Views: 2762

There's more to it than that, your compay would have to be paying maintenance to be entitled to support. Check with whomever would know about that in your organization.
by chulett
Mon Dec 06, 2010 8:38 am
Forum: General
Topic: Datastage Scheduler stopped working
Replies: 10
Views: 2762

I'd still get support involved. The last 7.5.x version was 7.5.3, perhaps somewhere in those releases your issue is addressed.