Search found 42189 matches

by chulett
Mon Apr 02, 2007 5:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal Termination of Stage- Could not get much from forum
Replies: 10
Views: 3124

[image of Ray sitting on porch in rocking chair]

Welp... that's called 'experience', young feller. Yep, experience.
by chulett
Mon Apr 02, 2007 4:48 pm
Forum: General
Topic: Datastage ADministrator Commands
Replies: 13
Views: 10544

I lifted them from an earlier post and yes, they seemed to have moved around. A simple search on the site took me here:

http://www-306.ibm.com/software/data/u2 ... y/952univ/

Looks like a good starting point. :wink:
by chulett
Mon Apr 02, 2007 4:46 pm
Forum: General
Topic: Unable to use Job parameter in JobControl
Replies: 5
Views: 2203

Manishk - Curious why we are talking about manual Job Control code if you are allegedly using a 'Job Sequence'?


[waves to John]
by chulett
Mon Apr 02, 2007 8:04 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Fatal error
Replies: 4
Views: 2730

Reread the linked post. It's not a problem you can solve. Never implied there was any problem with your job - you simply called a web service that was unavailable for an unknown reason. You did about all you can do in that situation - unless you own the service, of course - wait and try again.
by chulett
Mon Apr 02, 2007 8:00 am
Forum: General
Topic: Adding enviornmental Variable
Replies: 18
Views: 5692

:? I don't believe the question as asked is being addressed:

sjordery wrote:Actually I want to assign some values to the enviornment variables from a particular job during run time

It's not about creating and using variables during runtime but about creating and setting variables during runtime.

Carry on.
by chulett
Mon Apr 02, 2007 7:40 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Fatal error
Replies: 4
Views: 2730

There was a problem and someone fixed it. One of many Google results for that error message:

http://www.checkupdown.com/status/E500.html
by chulett
Mon Apr 02, 2007 7:36 am
Forum: General
Topic: Row by row processing in sequence job
Replies: 13
Views: 4722

I doubt you'll be able to use the Notification Activity stage, doesn't seem like it will support your needs. Consider writing a custom routine where you can pass in the pertinent details and leverage either DSSendMail directly or DSExecute your operating system's mailx command.
by chulett
Mon Apr 02, 2007 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Last digit gets truncated while loading into Oracle ODBC Stg
Replies: 8
Views: 2769

Good to know. If you can, please post the ECASE number for this patch, it will help others with the problem get the solution as easily as possible.
by chulett
Mon Apr 02, 2007 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File & data level validations
Replies: 8
Views: 2355

As noted - perhaps you should define what you mean by 'file level validation'. Otherwise, people have to guess.
by chulett
Mon Apr 02, 2007 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle Control M Character
Replies: 17
Views: 5321

I too faced similar problem.. I think it is due to the file FTP from windows to unix server. Typically - yes. Or sometimes people map a UNIX drive in Windows and just drag and drop files. ps. That won't "solve" the problem, per se. To solve it one would need to be able to read and handle DOS files ...
by chulett
Mon Apr 02, 2007 6:22 am
Forum: General
Topic: Row by row processing in sequence job
Replies: 13
Views: 4722

Sequence jobs do not process records - they run other jobs or activities, so in general you get the notion of processing records in one out of your head. However - if you are on a recent 7.5.x version, then you have the UserVariables Activity stage along with the Start Loop and End Loop stages. You ...
by chulett
Mon Apr 02, 2007 6:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XFM problem due to fixed width file delimited
Replies: 7
Views: 1983

Try sliding your Columns over to the right and setting the last field's Incomplete column attribute to Replace.
by chulett
Sun Apr 01, 2007 2:55 pm
Forum: General
Topic: Executing multiple commands from a file
Replies: 7
Views: 3159

Re: Executing multiple commands from a file

I tried to keep both commands in seperate file and mentioned that file in the execute command activity.Its not getting executed.I tried with file extensions .txt, .bat, .exe. The .bat extension should have worked. What happened when you tried that? ps. You really don't want to be using the root of ...
by chulett
Sun Apr 01, 2007 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Last digit gets truncated while loading into Oracle ODBC Stg
Replies: 8
Views: 2769

And? You've got your answer - you will need to adjust your metadata for use in the ODBC stage, it seems. You can thank Bill Gates for that. Only question in my mind is: does it make a difference if you use the Oracle 'wire' drivers over the 'non-wire' ones? Which have you tried? Rhetorical question,...
by chulett
Sun Apr 01, 2007 7:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: WHich is faster?
Replies: 9
Views: 2120

Yes - of course - you are better off matching the first action to whichever you will have 'more' of. This lessens the number of times you burn two actions to perform one. My two cents on the 'dual action' actions? Don't use them. To me they are a crutch supporting a poor job design, a dangerous shor...