Search found 42189 matches

by chulett
Thu Nov 22, 2007 8:37 am
Forum: General
Topic: diffrence between datastage 7.1 and datastage 7.5
Replies: 5
Views: 1827

Let's get this out of the way first, give Ray a break today:

Policy Note

We don't do "urgent" or "ASAP" here. All posters are unpaid volunteers. If you want urgent help sign up with your support provider for premium service, and learn the true cost of "urgent".
by chulett
Thu Nov 22, 2007 8:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Input
Replies: 5
Views: 2278

Any advice you find here will be for versions before 8.x, no clue what changes that version brings to the table. Suggest you check with your official Support provider. Please post any resolution you find back here to help anyone with the same problem in the future!
by chulett
Thu Nov 22, 2007 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Non root install - Impersonation mode
Replies: 3
Views: 1038

Permissions.

Are you having this problem or was this just a hypothetical?


ps. If your 'a' was like a 'bump' post or some other cry for attention, there's no need for that here.
by chulett
Thu Nov 22, 2007 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage: Delete executable (parallel job)
Replies: 7
Views: 2743

Re: Datastage: Delete executable (parallel job)

Based on this, we have tried to recompile the job, and it did not work. We have tried also to import the job from the previous stage (pre-production) that it is a mirror from production, and it didn't work neither. Simply saying "it didn't work" does help us help you at all. What didn't work about ...
by chulett
Thu Nov 22, 2007 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer error
Replies: 2
Views: 1054

Welcome aboard. Kind of confusing for a first post, but let's see... So, this has nothing to do with AutoSys or how you run the Sequence job, right? What is happening is somewhere in your Sequence job you are trying to run a script and that script is failing. Right? If that's the case, we'd need mor...
by chulett
Thu Nov 22, 2007 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ExecCommand
Replies: 17
Views: 3781

Excellent... solved in the first reply. 8) :lol:
by chulett
Wed Nov 21, 2007 6:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ExecCommand
Replies: 17
Views: 3781

Forgot to mention that part - just 'start' as the command and everything else in the Parameter box. Thanks. The biggest thing to realize with that stage is you can't put "half" of the command in one box and the other half in the second box as, when they are combined to be executed, a space is left b...
by chulett
Wed Nov 21, 2007 4:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call Unix shelscript from job control
Replies: 3
Views: 1097

"Hmmm... I wonder how they are going to do that on a Windows server?"
by chulett
Wed Nov 21, 2007 1:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Run a Query on Hashed Files using Command Line
Replies: 3
Views: 1084

Well, that's a new bit of advice. I understand what you are saying and agree better safe than sorry, just don't recall seeing that trotted out before. :wink:
by chulett
Wed Nov 21, 2007 1:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ExecCommand
Replies: 17
Views: 3781

From what I understand - yes, it does come 'free' with EE. Someone may have chosen not to install it. Or, as noted, there are other alternatives.
by chulett
Wed Nov 21, 2007 1:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: conversion from datatype 'VARCHAR' to 'NUMERIC' is not allow
Replies: 6
Views: 3092

I don't know Sybase but I doubt you use a plus sign for concatenation, so it's probably trying to convert both fields to numbers so it can add them together. :D

In Oracle you would use "||" for that purpose, for example, you need to lookup the Sybase equivalent.
by chulett
Wed Nov 21, 2007 10:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: conversion from datatype 'VARCHAR' to 'NUMERIC' is not allow
Replies: 6
Views: 3092

Probably PR_ID. How is it declared in your job?
by chulett
Wed Nov 21, 2007 9:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ExecCommand
Replies: 17
Views: 3781

Sure, if you have the MKS Toolkit then you have alot of other options, including scripting something.
by chulett
Wed Nov 21, 2007 9:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Optimisation of hashed file population
Replies: 7
Views: 2086

Yes, 'cat' as in the operating system command to concatenate files. The Filter option is something you can enable in the Sequential file stage to allow it to run O/S commands which write to standard out - then the stage reads that input stream as if it were a file. You could cat files in there so as...
by chulett
Wed Nov 21, 2007 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ExecCommand
Replies: 17
Views: 3781

In DOS? Hmmm....

Maybe using 'start'? Or perhaps a generic batch file in a fixed location that does a 'call' to the correct batch file?

Really getting into the WABAC Machine for that stuff. :wink: