Search found 42189 matches

by chulett
Tue Mar 11, 2008 12:07 pm
Forum: General
Topic: Knowing the timestamp of jobs/sequencers
Replies: 2
Views: 1310

The Manager will show you last modified. Search the forums for DS_AUDIT for examples of what activities are tracked by DataStage.
by chulett
Tue Mar 11, 2008 12:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract data from VSAM file using CFF stage
Replies: 9
Views: 3070

He can't with NLS enabled - here is the original thread where that came to light. With the assumption that the data will be in EBCDIC with NLS enabled, perhaps you actually have ASCII data in the file and now they are getting converted to garbage? Can you look at your source file outside of DataStag...
by chulett
Tue Mar 11, 2008 10:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml input stage v8.0 AIX
Replies: 6
Views: 1231

Depends on what section you found it in - 'Fixed in this release' or 'Known issues'.
by chulett
Tue Mar 11, 2008 9:52 am
Forum: General
Topic: NLS_LANG value
Replies: 3
Views: 3840

If you are US-American and you beleave - as nearly all co-citizens do - fully that neither behind pacific nor behind atlantic nor behind the great seas in the north nor behind the caribean sea there is any kind of intelligence than you can leave it untouched. Come on, don't hold back... tell us how...
by chulett
Tue Mar 11, 2008 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Protecting a Project
Replies: 7
Views: 1291

Re: Protecting a Project

attu wrote:No one can edit or compile jobs or execute them.

So... would this be some kind of 'archival' project? :?
by chulett
Tue Mar 11, 2008 9:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to make a loop indefinite
Replies: 2
Views: 779

It would help to search for 'infinite' rather than 'indefinite' as well. :wink:
by chulett
Tue Mar 11, 2008 9:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing is taking too much time
Replies: 9
Views: 2340

Can't help you there. Is your install disk... full? Or highly fragmented, perhaps? Anything else behaving oddly or literally just this?
by chulett
Tue Mar 11, 2008 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing is taking too much time
Replies: 9
Views: 2340

:? Checkpoints are a feature of Sequence jobs, is that what you mean? I don't see how that could take anything other than moments.
by chulett
Tue Mar 11, 2008 7:08 am
Forum: Enhancement Wish List
Topic: CSV support in parallel jobs
Replies: 5
Views: 2817

Yah... still trying to nail them with that rusty six inch nail, I see. :wink:
by chulett
Tue Mar 11, 2008 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: percent_rank() function in Datastage
Replies: 11
Views: 6382

Ah... one of those 'gory details' people don't seem to want to burden us with. :wink: Perhaps the question is: is there an equivalent in TeraData?
by chulett
Tue Mar 11, 2008 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Having Same Column name twice in target DB stage
Replies: 7
Views: 1764

I guess 'INPUT VAL' is what you substituted for the actual parameter markers in the job? As Ray notes, you'll need to use a different name for the second version of the 'same column' to hold the old value. Then custom sql is required to map everything into the corresponding parameter markers so you ...
by chulett
Tue Mar 11, 2008 6:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer was entered, but never exited
Replies: 7
Views: 4250

gillu wrote:Both sequencers are "Any"

Double check. That message only comes from 'All' Sequencers in my experience.
by chulett
Tue Mar 11, 2008 6:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: percent_rank() function in Datastage
Replies: 11
Views: 6382

Silly question, but why not just continue to do that in Oracle?
by chulett
Tue Mar 11, 2008 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: check that 'dbx' and 'sed' are installed and on your PATH
Replies: 4
Views: 2260

Re: check that 'dbx' and 'sed' are installed and on your PAT

swati1_sinha wrote:Any suggestions???

Search. It's been discussed here a number of times.
by chulett
Tue Mar 11, 2008 12:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Result after the DSGetJobInfo() not interpretable
Replies: 7
Views: 1980

Which job are you checking? The current job? Then use DSJ.ME for the handle. For another job, you'll need to 'attach' to it first to establish the handle and there is a specific function for that. However, you'll need to write a routine to handle all of this correctly - attach, get job information (...