Search found 42189 matches

by chulett
Thu Jun 30, 2011 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborted 'glibc detected' error
Replies: 11
Views: 8804

malloc(): memory corruption (fast) ? In your shoes, I be getting that in front of my official support provider.
by chulett
Thu Jun 30, 2011 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg Stored Procedure Job
Replies: 7
Views: 2565

For SQL Server, I would imagine you could do something similar with the Stored Procedure stage set to ODBC.
by chulett
Thu Jun 30, 2011 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key Generator questions
Replies: 41
Views: 8392

Angle brackets, not square brackets.
by chulett
Wed Jun 29, 2011 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The link contains more than one repetition rule
Replies: 2
Views: 5214

Re: The link contains more than one repetition rule

SURA wrote:XML_Input_12,0: Error: The link contains more than one repetition rule
The repetition element is the one you marked as the 'key' field in the XML Input stage... sounds like you marked more than one. You can't do that.
by chulett
Wed Jun 29, 2011 8:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing special characters,spaces,nulls in multiple columns
Replies: 23
Views: 29083

Who said there was none of that? Well... no drum but I've seen plenty of the others and 8-inch floppies to boot. Heck, the first system I worked on professionally had a CDC (Hawk?) drive with one fixed platter and a removable cartridge... and from what I recall they held 5 MEGABYTES apiece. Big stuf...
by chulett
Wed Jun 29, 2011 8:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal error
Replies: 1
Views: 841

Not without more information. What exactly are you doing in the ODBC stage?
by chulett
Wed Jun 29, 2011 8:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key Generator questions
Replies: 41
Views: 8392

It's a "shell" command, you can't just type it there and expect it to work. So that means using ExecSH in a routine and then using that routine in the UVA stage which will capture the output of the command when you pass it back out.
by chulett
Wed Jun 29, 2011 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help In Logic.
Replies: 7
Views: 2788

The 'key change column' is set to 1 (true) the first time it see a new value in the defined group. Every time that same value follows, the key change column is set to 0 (false) to show it hasn't changed. So basically, every time it is true set your stage variable that controls the 'note seq' value t...
by chulett
Wed Jun 29, 2011 7:48 pm
Forum: General
Topic: Sequence not running jobs in parallel
Replies: 10
Views: 4104

Sounds like it may be waiting for each individual job rather than starting all and then doing the group wait thing.
by chulett
Wed Jun 29, 2011 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset is occupying more space than file
Replies: 4
Views: 3434

Doesn't the post you linked to answer all of your questions?
by chulett
Wed Jun 29, 2011 2:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help In Logic.
Replies: 7
Views: 2788

You could also leverage the Sort stage and its ability to add a 'key change column' which would simplify the work needed in the transformer.
by chulett
Wed Jun 29, 2011 2:42 pm
Forum: General
Topic: Sequence not running jobs in parallel
Replies: 10
Views: 4104

From what I recall, it should run them in parallel.
by chulett
Wed Jun 29, 2011 2:41 pm
Forum: General
Topic: Sequence not running jobs in parallel
Replies: 10
Views: 4104

Sorry, had to move this to the correct forum. :wink: