Search found 42189 matches

by chulett
Tue Aug 26, 2008 1:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error: Improper data type
Replies: 8
Views: 9442

Welcome. :D

So you've looked at the generated source code around the line number as noted in the error? Is it having a problem when you attempt to use the stage variable or when you are setting it?
by chulett
Tue Aug 26, 2008 1:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Instances
Replies: 3
Views: 1498

Re: Multiple Instances

I understand changing the reusable job to allow multiple instances doesn't solve the problem Actually, that sounds like the only solution you have. Both the Sequence job (no 'r' by the way) itself and the Server job inside will need to be multi-instance jobs. And yes, the Sequence's invocation ID c...
by chulett
Tue Aug 26, 2008 1:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Problem
Replies: 1
Views: 630

Using the FTP stage? Have you verified your metadata, the field types and sizes are indeed correct?
by chulett
Tue Aug 26, 2008 1:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp - 1
Replies: 6
Views: 2591

DateFromDaysSince() I would think.
by chulett
Tue Aug 26, 2008 1:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJ.LINKROWCOUNT not working properly for PX job
Replies: 12
Views: 7506

You would need to upload it to any of the many free image servers and then use [img] tags to link to it in a post. Those sites will generate the links for you, typically.
by chulett
Tue Aug 26, 2008 1:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: execute command problem
Replies: 8
Views: 1645

What happens when you run the command yourself from the command line, does it behave as expected? Also, where did the dot come from at the beginning of the command? Actually, why don't you detail what you put in each 'box' in the stage.
by chulett
Tue Aug 26, 2008 1:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion from 7.5.1a to 7.5.3
Replies: 1
Views: 563

Depends. 'Upgrade in place'? Nope. Build a new server and import from the old one? Yes.
by chulett
Tue Aug 26, 2008 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSJ.LINKROWCOUNT not working properly for PX job
Replies: 12
Views: 7506

And "Stage Name from PX job" means a hard-coded value or something derived? The confusion is the fact that you showed an example of a stage name with a "dot invocation id" tagged on to it and that's not correct.
by chulett
Tue Aug 26, 2008 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: new user defined coumn with value in transformer
Replies: 1
Views: 551

Welcome aboard. :D

Not to sound like a smarty pants, but go ahead. That sounds perfectly reasonable, just add the column and setup the derivation for it. What part are you having a problem with?
by chulett
Tue Aug 26, 2008 10:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to open Properties of Job Stages within a sequence
Replies: 11
Views: 5077

You have to request it. You will not find it out there for download.
by chulett
Tue Aug 26, 2008 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Parameter value with double quotes
Replies: 8
Views: 2582

Don't pass the double-quotes in the first place, they are completely unnecessary there unless you have something like <shudder> a mixed-case table name.
by chulett
Tue Aug 26, 2008 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Routine
Replies: 1
Views: 838

Don't try to put a timestamp in a date field.
by chulett
Tue Aug 26, 2008 8:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with @OUTROWNUM
Replies: 6
Views: 1265

How many nodes?
by chulett
Tue Aug 26, 2008 8:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shelll Script for row count
Replies: 16
Views: 4217

Wait... you don't want to save things in Oracle or you do? :?

If not, where or in what format do you want to store things?
by chulett
Tue Aug 26, 2008 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with @OUTROWNUM
Replies: 6
Views: 1265

Running on how many nodes? What stage is the constraint in?