Search found 42189 matches

by chulett
Tue Sep 23, 2008 3:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splitting the coulmn in a record
Replies: 14
Views: 4100

Write them out with linefeeds in place of the semi-colons so they end up as separate records.
by chulett
Tue Sep 23, 2008 3:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using Parameters in the Email Notification Stage
Replies: 4
Views: 1487

I don't have access to that version, but I don't believe so. Hopefully someone will confirm one way or the other.
by chulett
Tue Sep 23, 2008 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: core file
Replies: 2
Views: 1585

Not sure what there is to explain. Failed UNIX processes that crash 'core dump' and create a 'core' file that people with the right tools can use to analyze the crash. Google for 'core dump' for more information.
by chulett
Tue Sep 23, 2008 1:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Auto Purge does not work
Replies: 5
Views: 1453

auto purge setting will only work for new jobs that have auto-purge enabled before they are created. For existing jobs you can export/import them to enable auto purge setting. Hardly. You just need to enable it for them. One at a time, unfortunately, but there's absolutely no need to export/import....
by chulett
Tue Sep 23, 2008 1:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Auto Purge does not work
Replies: 5
Views: 1453

Immediate Purge is the default from the Director. What matters is if, in the Auto Purge section, the Enabled for this job option is checked. Doesn't matter if it is greyed out when you look, it only becomes active (changeable) what you click the Auto-Purge radio button.
by chulett
Tue Sep 23, 2008 10:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Pass dataset field value to job parameter/parameter s
Replies: 2
Views: 1626

Write it to something... simpler, like a flat file. Then you have many more options re: retrieval. For example, you could cat the value, capture that in a Sequence job and then pass that output easily to any downstream job parameter.
by chulett
Tue Sep 23, 2008 9:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append system date and time to a file name in Seq File Stag
Replies: 10
Views: 11517

You might want to expand on that a little, seeing as how you cannot have a parameter value that references another parameter.
by chulett
Tue Sep 23, 2008 9:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling DataStage Sequences with Zeke
Replies: 3
Views: 2752

We have a single generic script that launches jobs (via 'dsjob' of course) that our Enterprise Scheduler Control-M uses for all DataStage jobs. Pretty sure a couple of examples have been posted here in the past, some more complex than others, that a search for dsjob should turn up. If you can weed t...
by chulett
Tue Sep 23, 2008 8:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_BUfferOperator error
Replies: 4
Views: 3973

Re: APT_BUfferOperator error

tsktsk123 wrote:Please ensure that you have sufficient scratchdisks in either the default or "buffer" pools on all nodes in your configuration file.

Have you?
by chulett
Tue Sep 23, 2008 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append system date and time to a file name in Seq File Stag
Replies: 10
Views: 11517

For example, assuming a job parameter named FILE_TIMESTAMP, you would specify the filename as:

FileName_#FILE_TIMESTAMP#.txt

Does that help?
by chulett
Tue Sep 23, 2008 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacing DB2 enterprise stage with teradata enterprise stag
Replies: 11
Views: 2839

If you had just made the changes manually rather then looking for an 'easier' way, you probably would have been done by now. :wink:
by chulett
Tue Sep 23, 2008 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: memory error
Replies: 2
Views: 1319

Ah... lost me for a second. Uriah Heep. D'oh. I really don't understand why people feel the need to hand-type error messages into a post. That introduces errors / ommissions / typos and makes searching for their 'error' difficult if not impossible. Please people, copy and paste. Copy. Paste.
by chulett
Tue Sep 23, 2008 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need suggestion
Replies: 2
Views: 851

Clarify exactly what trigger(s) you have coming from the Routine Activity you are having this issue with and where they go.
by chulett
Tue Sep 23, 2008 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar to Date format
Replies: 42
Views: 10909

Suggest you actually answer the question I posted.