Search found 42189 matches

by chulett
Mon Nov 17, 2008 10:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameter
Replies: 7
Views: 1708

Just do it. Declare it as a parameter and enclose the parameter name in hash/pound signs in your derivation.
by chulett
Mon Nov 17, 2008 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential File problem
Replies: 3
Views: 4347

From the manual:

To implement a DOS newline, use the Record delimiter string property set to "\R\N" or choose Format as -> DOS line terminator from the shortcut menu.
by chulett
Mon Nov 17, 2008 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Publishing activation date for different Time Zones in XML
Replies: 8
Views: 2571

In other words, nothing specific for timezones exist, you'll need to spec out and write your own.
by chulett
Mon Nov 17, 2008 8:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wait For File Activity Stage error
Replies: 3
Views: 1750

There was no suggestion, simply explanation. You need to decide how long of a wait is appropriate and what happens when that time expires without the file arriving.
by chulett
Mon Nov 17, 2008 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin command error
Replies: 7
Views: 1970

Interesting, it's different for HP-UX, PA_RISC v. Itanium? I'll have to remember that.
by chulett
Mon Nov 17, 2008 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML input and Output stages in PX
Replies: 8
Views: 5658

I'd wager you could find something locally or online as well. XML is XML, DataStage or no.
by chulett
Mon Nov 17, 2008 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: where is a DS job stored in the unix server
Replies: 9
Views: 3408

thanks craig..so I guess it wont be staraightaway possible to replace the job design with the recent version of it from a versioning tool. Certainly possible, it's just that (as noted) you'd need to export the job design first to a .dsx (or .xml) file and them import that back into the appropriate ...
by chulett
Mon Nov 17, 2008 7:53 am
Forum: General
Topic: Handeln with ExpDate derivation in datastage
Replies: 14
Views: 7455

yollsonlegrand wrote:ANy idea will be helpfull.

You could always open a case with your official support provider and have them help you.
by chulett
Mon Nov 17, 2008 1:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Director Logging
Replies: 10
Views: 2883

AFAIK, that compile that you are doing is how one must remove instances from the Director. As for the timing, depends on your job design... perhaps a Sequence job would help? :?
by chulett
Mon Nov 17, 2008 1:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash Files
Replies: 2
Views: 1038

Define huge. Default (32bit) hashed files cannot grow beyond ~2GB. For hashed files larger than that, you'd need to create them as 64BIT, something you can't do via the stage so you'd need a routine or script.
by chulett
Mon Nov 17, 2008 1:21 am
Forum: General
Topic: DSJOB syntax for all jobs in a project
Replies: 4
Views: 9038

Not possible. You'll need to loop through all of the jobs in the project, a call to 'dsjob' per job to fetch the job's log.
by chulett
Mon Nov 17, 2008 1:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Order By before Hashed Stage
Replies: 11
Views: 2984

What are the Key fields in the hashed file? That is the pertinent information needed here.
by chulett
Sun Nov 16, 2008 10:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wait For File Activity Stage error
Replies: 3
Views: 1750

Why wait only 5 seconds for the file to arrive? The error simply means the file did not arrive, you did not have a failure trigger and have enabled 'Automatically handle activities that fail' in the Sequence job.
by chulett
Sun Nov 16, 2008 10:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetJobInfo DSJ.JOBCONTROLLER values after reset
Replies: 5
Views: 2962

Ok, I'm seeing the same behaviour as you are, Sequence running Sequence. After the first stand-alone run post abort/reset of my "B", it still shows the original controller when interogated. However, if I run it stand-alone after that again, then it comes back empty. It's almost as if it is reporting...
by chulett
Sun Nov 16, 2008 9:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSGetJobInfo DSJ.JOBCONTROLLER values after reset
Replies: 5
Views: 2962

I don't recall this coming up before, so I built a quick harness. Ran a test with a Sequence job running an existing Server job and it behaved as one would expect - run it under Sequence control and it showed that when interogated, run standalone before or after that and it returned an empty value. ...