Search found 42189 matches

by chulett
Wed Jan 28, 2009 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error calling DSRunJob([b]JOBNAME[/b]), code=-14
Replies: 3
Views: 1616

More like 90 seconds and there's more to understanding the problem than simply rerunning the offending job. A search for "Timed out while waiting for an event" would turn up all manner of previous conversations on this topic.
by chulett
Wed Jan 28, 2009 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re:Run the jobs through command line
Replies: 3
Views: 893

From the manual side, either "Developer's Guide" pdf has a chapter on the Command Line Interface, which is where you'll find dsjob documented.
by chulett
Wed Jan 28, 2009 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Designer Problems
Replies: 2
Views: 3324

I've got no idea personally, but wondering if you've tried googling for your error phrase? "Object reference not set to an instance of an object" got quite a number of hits for me and some looked... informative.
by chulett
Wed Jan 28, 2009 7:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: issue on doublle quotes
Replies: 3
Views: 1493

For that approach to work, sounds like you'll need to ensure your record string has all the proper quotes and delimiters in place when you send the string to the container, and then tell it to write to the reject file without adding any new quotes to the record. Do this by setting the "quote&qu...
by chulett
Wed Jan 28, 2009 7:27 am
Forum: General
Topic: How to find the Sequence for the particular job
Replies: 13
Views: 3401

eostic wrote:...but isn't the original question the "opposite?" ....ie...given Job X, tell me the Sequences that invoke it?
The opposite of what - what I posted? Did anyone try it? That sure as heck is what I *thought* it did, heck I even tested it for frak's sake. :wink:
by chulett
Wed Jan 28, 2009 7:22 am
Forum: General
Topic: issue in ETL (Datastage V .8.0.1) regarding SFTP of a file
Replies: 3
Views: 1625

Secure FTP is still a feature that is coming, from what I recall, so your only option is to build a script to leverage it. If this is really a TX product question, you'd be better off posting over in the dedicated TX forum, which is where those experts hang out. For all I know, the former Mercator p...
by chulett
Wed Jan 28, 2009 7:17 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI console
Replies: 10
Views: 5137

Ernie is probably going to have to pop in here and clarify things, but I believe that RTI is free for the asking nowadays. I don't recall off the top of my head all of the pieces you have to install, but there is at least an "RTI Server" that needs to be out there wherever you'll be deploy...
by chulett
Tue Jan 27, 2009 8:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TXT file generation
Replies: 2
Views: 1732

I'm not sure what your example is trying to show with the double-quotes. A UNIX file would use a line termination character of LF rather than CR, which I assume is what you mean by 'Enter'. So... I think what you need is to enable is the "Omit last new-line" option on the Format tab. Let u...
by chulett
Tue Jan 27, 2009 5:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compile:"Referenced StartLoop cannot be found on input
Replies: 3
Views: 6536

Sorry, not gonna guess. Either post a screenshot of your design or give us the "ascii art" version wrapped in

Code: Select all

 tags. Use Preview to get everything lined up properly.
by chulett
Tue Jan 27, 2009 4:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting list of Jobs in Windows environment
Replies: 19
Views: 5355

Well... don't know about that but glad you got it all worked out. :wink:
by chulett
Tue Jan 27, 2009 2:12 pm
Forum: General
Topic: How to find the Sequence for the particular job
Replies: 13
Views: 3401

Perhaps something like this... select DS_JOBS.NAME SequenceName FMT '40L' from DS_JOBOBJECTS, DS_JOBS where EVAL DS_JOBOBJECTS."@RECORD<3>" = 'YourJobNameGoesHere' and EVAL DS_JOBOBJECTS."@RECORD<2>" = 'CJSJobActivity' and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO
by chulett
Tue Jan 27, 2009 1:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting list of Jobs in Windows environment
Replies: 19
Views: 5355

What didn't work about it? Worked fine for me... make sure you're not typing a space between the two double-quotes. It might look like there's one there but there isn't.
by chulett
Tue Jan 27, 2009 1:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to initialize plug-in
Replies: 3
Views: 1746

Could you post the relevant section from your dsenv file, please, so we can see the actual changes you made to it?
by chulett
Tue Jan 27, 2009 1:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting list of Jobs in Windows environment
Replies: 19
Views: 5355

Multiple ways I'm sure, but one that comes to mind uses the DOS "find" command:

Code: Select all

find /v /c "" YourFile
by chulett
Tue Jan 27, 2009 11:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting list of Jobs in Windows environment
Replies: 19
Views: 5355

Redirect the output of the command to a file:

dsjob blah-blah > filename