Search found 42189 matches

by chulett
Thu Jun 10, 2010 7:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Concern -- masking of an error
Replies: 3
Views: 1679

If you haven't done so already, do an exact search for When checking operator: Defaulting and see if any of the 43 other matches help you with this decision, that or help you correct rather than demote it. :wink:
by chulett
Thu Jun 10, 2010 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterpirse Stage - Records rejected without warning
Replies: 11
Views: 3873

I'm assuming the 'n' that were rejected were a subset of the 'x' you tried to load, yes? Have you captured/identified the rejects? Seen any common issues with them?
by chulett
Thu Jun 10, 2010 7:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Nanosecond
Replies: 5
Views: 1886

Or a really... precise... SLA. :wink:
by chulett
Thu Jun 10, 2010 4:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Nanosecond
Replies: 5
Views: 1886

I'm assuming you really mean microseconds rather than nanoseconds... yes?
by chulett
Thu Jun 10, 2010 4:36 pm
Forum: General
Topic: Parsing xml messages using datastage
Replies: 4
Views: 2789

You would 'Add to Schedule' three times at different times of the day. You'll still just have one job showing in the Status and Log views, but it will list three times on the Schedule view.
by chulett
Thu Jun 10, 2010 8:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while loading data to DB2 table
Replies: 8
Views: 6613

Search. I'm assuming it looks for a more 'generic' name that is linked to the proper versioned file and I've seen that link creation fail (for whatever reason) during setup. Manually creating it gets you going again. My guess for the solution here based on personal experience with other databases. :...
by chulett
Thu Jun 10, 2010 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset
Replies: 11
Views: 2701

Prudent, perhaps. :wink:
by chulett
Thu Jun 10, 2010 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while loading data to DB2 table
Replies: 8
Views: 6613

Do an exact search for Error loading "orchdb2op" and see if any of the other people having the same issue help you out.
by chulett
Thu Jun 10, 2010 6:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reduce date by a day in job control
Replies: 4
Views: 1444

Exactly, simply saying something is "not working" doesn't help anyone help you. :? Make liberal use of the DSLogInfo() function to log your intermediate values if you are unsure where exactly things are going wrong. That or use the Manager to test your job and tweak it to pass back more th...
by chulett
Thu Jun 10, 2010 6:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic RDMS
Replies: 3
Views: 1065

Do those stages support user-defined DDL for table creation? If so, I would imagine that you could simply adjust the syntax to create a volatile / temp table. Not having used either of those, I have no clue what they can or cannot do. What about ODBC? Is that an option for you here? Those kind of ta...
by chulett
Thu Jun 10, 2010 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset
Replies: 11
Views: 2701

From what I recall, you give it 'the name' and it adds the extension on automatically.
by chulett
Thu Jun 10, 2010 6:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reduce date by a day in job control
Replies: 4
Views: 1444

Perhaps just?

Code: Select all

FILEDATE = DD : MM : YYYY
You could also simply use Convert() to remove any delimiters that OConv() added to the date rather than chopping it up and reassembling it.
by chulett
Thu Jun 10, 2010 6:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic RDMS
Replies: 3
Views: 1065

Welcome. The dropdown in the DRS stage will show you what databases are support. If there is no native support for your database of choice then you may be able to fall back to ODBC (which should be listed) as long as you have the ODBC drivers for your database. Me, I have no clue if ODBC based Terad...
by chulett
Thu Jun 10, 2010 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Upsert option
Replies: 23
Views: 11656

I've also seen that SIGBUS error get thrown by buggy Oracle client versions. Mentioned earlier that I thought it would be prudent to see about upgrading your Oracle client.
by chulett
Thu Jun 10, 2010 5:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Running only selected jobs in same template
Replies: 5
Views: 1471

Assuming that means a Sequence job, the answer is no - at least from the Sequence itself. You could, of course, run them individually from the Designer... or perhaps build a temporary Sequence with just the bits you need.