Search found 42189 matches

by chulett
Wed Jun 02, 2010 9:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange problem about Warning Limit
Replies: 6
Views: 2807

OK, "job run level" seems to mean Sequence job's Job Activity stage? You can't control it there, it should be inheriting the warning level of the parent / controlling job.
by chulett
Wed Jun 02, 2010 9:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abort after 50 Warnings with no limit
Replies: 13
Views: 6963

If by "job run level" you mean "dsjob from the command line" then you need to use the -warn option as noted in this thread. Running from the Director you will have a Limits tab where that can be set.
by chulett
Wed Jun 02, 2010 6:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data and time function
Replies: 4
Views: 1577

Or add 1 to 3600? :?
by chulett
Wed Jun 02, 2010 6:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stagevariable
Replies: 2
Views: 5189

Lost. :?

You can't run "queries" in a transformer, only in a passive stage like an OCI stage, nor can queries refer to stage variables as their scope is local to the transformer. Use job parameters for that role instead.
by chulett
Wed Jun 02, 2010 1:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: subtract a day from DSJobStartTimestamp
Replies: 3
Views: 3411

86400 seconds since, if I recall correctly.
by chulett
Wed Jun 02, 2010 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregator problems using min() and count()
Replies: 5
Views: 2319

Do an exact search here for "It is not legal to set a reducer".
by chulett
Wed Jun 02, 2010 6:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to load data from target tables to dimension tables and
Replies: 2
Views: 1256

Nothing magical about dimensions or facts, bottom line they're just tables like any other table, so you "load" them like any other table. Only thing about them is their "relationship" and the RI you may or may not have between them, so they need to be processed in the proper orde...
by chulett
Wed Jun 02, 2010 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage variable not to be partitioned
Replies: 3
Views: 1149

Or... run it on one node. :wink:
by chulett
Wed Jun 02, 2010 5:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compatibility of Datastage 7.5 Server Edn with Oracle 11g
Replies: 6
Views: 2501

So, again... have someone ask these questions of Support through whatever channel you have available to you. Horse's Mouth and all. I doubt it is completely "incompatible" with 11g but unaware of any potential issues. You may need to connect to it with a lower client, for example. Check. L...
by chulett
Wed Jun 02, 2010 5:47 am
Forum: General
Topic: seq.nextval in select statement of an Oracle eneterprise.
Replies: 5
Views: 1871

I would assume so as well.
by chulett
Tue Jun 01, 2010 8:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CFF Stage problme in Parallel job
Replies: 7
Views: 4586

Please start your own post with the details of your problem, saying you have "the same error" doesn't really help us help you.
by chulett
Tue Jun 01, 2010 6:10 pm
Forum: IBM QualityStage
Topic: Warning in QualityStage job
Replies: 3
Views: 1860

And somehow that is a 'workaround'? Smells like a resolution to me. :?
by chulett
Tue Jun 01, 2010 6:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove two consecutive quotes in a csv file
Replies: 4
Views: 1519

Their "sample records" have no single quotes in them, so I didn't mention that. [shrug]
by chulett
Tue Jun 01, 2010 6:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregator aborting...
Replies: 12
Views: 3145

Dang, more guessing... sheesh.