Search found 42189 matches

by chulett
Thu Dec 21, 2006 1:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: regarding command line utility
Replies: 30
Views: 6046

Why not just open the job in Designer and click the button that looks like an Internet Explorer icon? It will generate a lovely little HTML document will all that stuff in it for you... no charge.
by chulett
Thu Dec 21, 2006 11:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleting Datasets - Windows
Replies: 9
Views: 3764

Does not PX for Windows come with the MKS Toolkit, in essence giving you a UNIX-like environment? So the other answer should apply as well, I would think. :?
by chulett
Thu Dec 21, 2006 10:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Moving columns from input tab to output tab
Replies: 10
Views: 4475

abc123 wrote:No, it doesn't work. I enabled RCP across the project, job and stage. I still see the Output tab as empty.

Of course it stays empty - that's why it's called Runtime Column Propagation. It happens automatically at runtime.
by chulett
Thu Dec 21, 2006 9:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CSV File : incorrect column number
Replies: 5
Views: 1253

Wow... that's the hard way. The easy way? Slide the Columns grid over the the right and investigate the 'Incomplete Column' option. Set the last column to 'Replace' rather than 'Error' and it will automagically give you a null in that column when Excel drops it off. :wink:
by chulett
Thu Dec 21, 2006 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with editing of Sequence Job Properties
Replies: 3
Views: 873

If you have two client versions installed, you'll need to install it twice - once to each location.
by chulett
Thu Dec 21, 2006 9:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Logs in Universe table ?
Replies: 11
Views: 5092

They both have three stages, sure, but other than that they're not "the same". Those are two totally different "Xfm" stages for one thing...
by chulett
Wed Dec 20, 2006 11:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation problem
Replies: 8
Views: 1866

From what I recall from this forum, delays like that can sometimes be attributed to multiple simultaneous compilation requests. The default license may only allow a single compile to occur at a time so subsequent requests 'queue up'.
by chulett
Wed Dec 20, 2006 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: string comparasion
Replies: 4
Views: 907

Perhaps you should add a little detail to your post. And example or two of your problem would be helpful, too. :wink:
by chulett
Wed Dec 20, 2006 11:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSRoutine
Replies: 24
Views: 4502

As I've already mentioned twice now, you'll need to use the second syntax in the previous post. Output from a command execution is returned in a dynamic array and the Field Marks are messing you up. If you check the first array element by adding <1> to the end of the variable, you'll just get the '0...
by chulett
Wed Dec 20, 2006 9:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling job backup
Replies: 5
Views: 1931

Go to Kim Duke's website and download the backup script you'll find in his Tips & Tricks section. It will export and date-stamp every Project on the server you attach to automagically - and you can schedule it. :wink:
by chulett
Wed Dec 20, 2006 9:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSRoutine
Replies: 24
Views: 4502

Since you are on a Windows server, you literally put "type" as the Command and the filename (or the job parameter you are using for the filename) in the Parameters section. That's it. Then you use the Activity Variable "StageName.$CommandOutput<1>" as the LHS of a custom trigger - and compare that t...
by chulett
Wed Dec 20, 2006 9:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSRoutine
Replies: 24
Views: 4502

Actually the error can be anything and not only 1. Ok, just going on the fact that you said "the sequential file is storing the output of procedure as Error num = 1 or 0". I developed a routine as follows: Would have been simpler to just "type filename" in an Execute Command stage and check the Com...
by chulett
Wed Dec 20, 2006 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: double quotes for the numbers
Replies: 6
Views: 1568

Seeing as how quotes are only for character strings, numeric values would fall into the "no quotes" camp.
by chulett
Wed Dec 20, 2006 7:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSRoutine
Replies: 24
Views: 4502

Re: DSRoutine

So now the sequential file is storing the output of procedure as Error num = 1 or 0. But my sequence is runing irrespective of whether the procedure fails or success. Of course - it does not have a clue that a '1' to you means there was a problem. The job ran just fine so the Sequence goes on with ...
by chulett
Wed Dec 20, 2006 6:55 pm
Forum: General
Topic: Help on Datastage earlier versions
Replies: 14
Views: 7069

Then what?