Search found 42189 matches

by chulett
Mon Jul 12, 2004 1:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version 7 - if sequencer under a sequencer fails
Replies: 3
Views: 933

Oh, I see... a hypothetical question. Your situation can be handled automatically in version 7.1 and onwards, as that is when the checkpointing of Sequencer jobs was introduced. Of course, the burden is on the developer to properly create the sequences to support that, but in general your answer is ...
by chulett
Mon Jul 12, 2004 12:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version 7 - if sequencer under a sequencer fails
Replies: 3
Views: 933

More details, please. What 7.x version are you running? Are you using the new checkpoints or is this home-grown restarting you are doing? Hard to say much of anything with what you've provided. Probably the best way to find out is... restart it! Then you can let us know how it works in your particul...
by chulett
Mon Jul 12, 2004 12:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Version 7.5
Replies: 7
Views: 2995

Hop over to ADN where they've just posted the fact that 7.5 is GA. There is an accompanying 37 page "What's New" pdf document in the File Library there that will answer all of your questions.
by chulett
Mon Jul 12, 2004 10:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String Comparison
Replies: 3
Views: 893

One way would be to simply substring the first character off and check to see if it is a '2'. If YourField[1,1] = "2" Then DoSomething Else DoSomethingElse You could also do something similar in a Constraint: YourField[1,1] = "2" Depends on what you mean by 'bring out'. You may n...
by chulett
Mon Jul 12, 2004 6:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage version 7 over version 5.2.1
Replies: 6
Views: 1496

MukundShastri wrote:Is there no extra feature for this in version 7 ?

Extra feature? No. You'll either need to hand code something, or use Yet-Another-Sequencer-Job to control your other sequences.
by chulett
Mon Jul 12, 2004 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control 7.0.22
Replies: 10
Views: 2097

In the same boat with Roy - 7.0.1 and no problems with Named Batches. Report it as a bug and let us know what comes of it.
by chulett
Sun Jul 11, 2004 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COBOL copybook in Oracle??
Replies: 2
Views: 912

Never heard of it. However, copybooks are just text and so there really shouldn't be anything magical about storing them in an Oracle database. The question is exactly how are they being stored? There are several options I can think of off the top of my head. They might be storing each 'line' as a r...
by chulett
Sun Jul 11, 2004 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: [Resolved]Promoted jobs with Version Controll
Replies: 5
Views: 1240

You're welcome? :?

:lol:
by chulett
Sat Jul 10, 2004 9:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get the month difference between two dates
Replies: 3
Views: 4922

Depends on exactly what you mean by 'months'. :?

Here is one method a quick search of the forum turned up. There were others.
by chulett
Fri Jul 09, 2004 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with EXPORT and Import
Replies: 2
Views: 1176

First thought - this is not the way to be 'promoting' jobs from environment to environment. That is what Version Control or the old Package/Release mechanisms were built to do. Now, if this is part of an upgrade test of a newer version, then never mind... That being said, is your QA environment setu...
by chulett
Fri Jul 09, 2004 1:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Upgrade
Replies: 5
Views: 2153

Mine have always been painless as well, using either the upgrade-in-place or the new-install-and-import methodologies. However, these were Server upgrades, not PX, so I can't comment on the ease of those. As has already been 'pointed out' more information would help, including perhaps some examples ...
by chulett
Fri Jul 09, 2004 6:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Underlying process in running a job
Replies: 1
Views: 726

When you say 'triggering a server job', do you mean from the command line? Or do you mean from within the 'server environment'? From the command line, there is the dsjob command. You should be able to find quite a bit of information here on using it, plus it is fully documented in the Server Job Dev...
by chulett
Fri Jul 09, 2004 6:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between Datastage's release 6x and 7x
Replies: 6
Views: 2008

If you actually have Version 7.x in your hands, then you've got the release notes. They are the 'readme' files on the various cdroms you received. There is typically one for the Client portion and one for the Server portion, and there is a "What's New in This Release" section in each. You'll also fi...
by chulett
Fri Jul 09, 2004 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP stage to retrieve the lastest file
Replies: 2
Views: 1009

Define 'latest file'. I'm sure you can make use of the FTP stage for something like this, but since it cannot handle multiple files (or even wildcards as far as I recall) you'll need to know which file you want before you get to the stage in your jobstream. You'd need to script something to go out t...
by chulett
Thu Jul 08, 2004 8:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of Stage Variable To Assign Nullable Values
Replies: 4
Views: 1374

I'm sure it can, the question is the method. It might be as simple as a precursor job (or even a Routine) that reads the sequential file to find the first TransNo and then passes it into the main job as a Job Parameter. You could then use it as the 'Initial Value' of the stage variable. You could us...