Search found 42189 matches

by chulett
Thu Jul 05, 2007 6:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleting records from a table - Fatal Error
Replies: 9
Views: 1752

If anyone had anything, they would post. That error is odd enough, I'd suggest you open a case with your official Support provider.
by chulett
Thu Jul 05, 2007 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: When does DS issue RDBMS commits
Replies: 2
Views: 903

It performs a 'final' commit when the stage closes. So, with the design you've shown, your first answer is correct.
by chulett
Thu Jul 05, 2007 6:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run a parallel job on pc( windows xp)
Replies: 2
Views: 1477

That's my reply to your rather short list of questions over there: Can DataStage 7.5x2 be installed on windows XP? Can DataStage 7.5x2 run parallel jobs? Besides the fact that no-one here will help you 'crack' anything, you'll need to do a better job of explaining what you need. This: "Any crack av...
by chulett
Thu Jul 05, 2007 6:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can i move an PDF object into my oracle target
Replies: 6
Views: 2003

I'm sorry that your first post here is for something 'asap' and 'urgent' as there really isn't any such thing here. If you urgently need help you should contact your official support provider, that's why your company pays them the big bucks. Here, we're all just volunteers who help when we can. No,...
by chulett
Thu Jul 05, 2007 12:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date loading problems
Replies: 7
Views: 1700

Ditch the quotes around the Link.Field, they turn it from your incoming value to a literal string. And you only need one concatenation: OCONV(ICONV(DSLink9.Field003,"D2-DMY[2,2,2]"),"D2-MDY[2,2,4]"):" 00:00:00.000" You sure your output date format should...
by chulett
Wed Jul 04, 2007 11:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine returning weired value for calculating factorial
Replies: 16
Views: 4497

How can we possibily have any idea what is wrong with your routine if we can't see what you've coded up? Post your routine code, wrapped in [code] tags so that it preserves your formatting.
by chulett
Wed Jul 04, 2007 11:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read Multiple Lines from Text file
Replies: 7
Views: 2186

That doesn't come close to answering the question. We know you need to read the file. You'd need to use the Sequential File stage as, bottom line, this is still just a 'text file' - just not one of the 'normal' variety you'd typically use the stage for. To accomplish that, you'll need to define the ...
by chulett
Wed Jul 04, 2007 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: trigger jobs by events and if datastage supports web service
Replies: 8
Views: 2726

It's not just for 8.x as a glance through the SOA Edition forum here would reveal. I'm currently using it with 7.5.1A, what kind of information are you looking for?
by chulett
Wed Jul 04, 2007 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table creation in Universe Database
Replies: 5
Views: 1133

You could use a UV stage in a job to create and populate your 'new table'.
by chulett
Wed Jul 04, 2007 11:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Packed Field not converted properly with CFF Stage
Replies: 6
Views: 1569

And yet oddly enough you can specify COMP-3. :roll:

As noted in the online help, you can right-click on the Source Column row for that field and select 'Edit Row'. In the COBOL definition in the bottom half you'll find a Usage option, where COMP-3 is one of the valid values.
by chulett
Wed Jul 04, 2007 9:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Automation
Replies: 6
Views: 1276

Manually, eh? Perhaps your user could be given a script or batch file to run after the file is dropped off. Are you at all familiar with the dsjob command? It is used to launch DataStage jobs from the command line, so could be used in a batch file to run the processing job - whic would then be run b...
by chulett
Wed Jul 04, 2007 8:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Automation
Replies: 6
Views: 1276

DataStage does not include a 'scheduler' - it leverages the native scheduling tools available in the O/S. For Windows, that would be 'AT'. All it can do is run a job at a fixed time. If you know that the file will be replaced on every 'X' day of the month, you can schedule your job to run sometime a...
by chulett
Wed Jul 04, 2007 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Status
Replies: 8
Views: 2524

Sheesh. It is the scheduler built into Windows and what the DataStage Director leverages when you say 'Add to Schedule'. It is pretty bare-bones feature wise. A UNIX server would have two equivalent processes: 'cron' and 'at'. Cron would be used to schedule repeating tasks whereas at is used to exec...
by chulett
Wed Jul 04, 2007 8:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Status
Replies: 8
Views: 2524

I donot understand that how would triggerring the jobs from Tivoli help in this ?? Do u mean that If a job sequence, which ran from Tivoli etc, has aborted then the message will be there itself... right ?? YES And am sorry, I did not understand what u meant by cron ?? Ah... that would be because yo...