Search found 42189 matches

by chulett
Sun Oct 15, 2006 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to avoid warngs when convert from varchar(10) to char(4)
Replies: 16
Views: 7008

Ensure that you don't send more than four characters to the target field.
by chulett
Sun Oct 15, 2006 10:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequence Trigger is not getting Triggered
Replies: 23
Views: 8841

Ok... played around more with this after noting your 'to be more specific' post where you introduced the Terminator Activity stage. It looks to be causing your issue, or again at least something close to your issue. Add in a trigger to a Terminator Activity stage and then trigger order does play a r...
by chulett
Sun Oct 15, 2006 9:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequence Trigger is not getting Triggered
Replies: 23
Views: 8841

I'm probably going to regret this, but can't let this end on that note. No, I'm afraid your assertation isn't true. Something else is still at work here. If you want to spend the time trying to figure it out, let us know, but for the sake of everyone else playing along in the home audience I need to...
by chulett
Sun Oct 15, 2006 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage installation
Replies: 3
Views: 1033

Well, first let's define what 'system' means and what exactly you are reinstalling every day. Are you talking about your Windows based DataStage Server - or the Client software on your individual PC you use to connect to it? Arnd is going for the former, I've got my money on the latter. Regardless, ...
by chulett
Sun Oct 15, 2006 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: logging text , final text message in terminator stage
Replies: 1
Views: 804

Read the help on the stage in the Designer's Guide manual, that will clear it up for you. Goofy suggestion, I know, but hey. Basically, every stage has a 'Logging Text' area on their General tab and that logs an informational message when the stage is triggered / started. Informational as in a green...
by chulett
Sun Oct 15, 2006 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer - Send STOP requests to all the running Jobs
Replies: 2
Views: 3169

Your understanding is correct. The stage in question is the Terminator Activity stage and it can be triggered like that. You need to ensure the TA stage is actually getting called when your jobs abort... Add a message to either the Logging Text on the General tab or to the Final Message Text on the ...
by chulett
Sun Oct 15, 2006 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MFILES & NOFILES
Replies: 5
Views: 1995

And if it hasn't been changed there, talk to your UNIX admin. Both values can be set in the kernel, from what I recall - one system wide limit and one per user limit. They may have just rebooted because they had been in changing those values...
by chulett
Sat Oct 14, 2006 2:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling of jobs
Replies: 2
Views: 651

Well... when it happens, let us know! More than likely, both will run just fine, especially if all the jobs are doing is reading. Databases are multi-user beasts, so that's not typically an issue. Even updates and inserts can happen to the same table at the same time. Typically. You haven't mentione...
by chulett
Sat Oct 14, 2006 8:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get Link Direction within Job via Routine
Replies: 8
Views: 1651

nishadkapadia wrote:I just used LinkTypes which worked fine. However, for jobs with only passive stages (luckily there were only a couple) wrote specifically to handle these.

Add one.
by chulett
Sat Oct 14, 2006 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deletion of output file
Replies: 39
Views: 6927

You could read the part where he asked you to expand on your "It's not working out" comment, how about taking a stab at that? There's nothing obviously wrong with what you've posted that I can see, but without specific examples of your problem - what error you are getting, what it is doing wrong or ...
by chulett
Sat Oct 14, 2006 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Taking backup using after job subroutine
Replies: 9
Views: 1909

Joyson, Kris linked you to one discussion, there are others out there for the searching that will help as well - this one, for example. Give it a good read, especially the second page where it starts to address the exact questions you have. Pretty much the only difference there is they need to erase...
by chulett
Sat Oct 14, 2006 8:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ExecSH cp command
Replies: 6
Views: 3377

You wouldn't need an 'array' for that, just pass more pieces in and parse them out accordingly in your routine. You already have a thread where you are discussing that very subject, why start another one? It just confuses things and wastes people's time coming up with suggestions that have already b...
by chulett
Sat Oct 14, 2006 8:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: STAGECOM Data structures & Hawk
Replies: 15
Views: 3630

Well... . Really don't think Hawk will, but at some point it certainly could break. In any case, it's ill advised and not supported in any way. . You've obviously found a way! . Nothing 'possible' about it, it's an excellent way to go. At the very least, some ideas on how you could roll your own. . ...
by chulett
Sat Oct 14, 2006 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ExecSH cp command
Replies: 6
Views: 3377

After the run when i checked with the director it is showing cp /folder/first.txt /folder/first_'date +%Y%m%d`.txt That's fine and exactly what it should be showing you as that is the command it needs to execute. Don't expect it to substitute the date as it won't. Well, 'exactly the command' except...
by chulett
Sat Oct 14, 2006 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI Stage Installaion.
Replies: 2
Views: 728

It would have been the 'DataStage Package Installer' a.k.a the dspackinst command. And as should have been noted in the other post, not the best way to do it. A maintenance mode 'installation' of the Server will allow plug-in installs into all projects and the template so new projects created after ...