Search found 42189 matches

by chulett
Mon Feb 05, 2007 7:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dspackinst - Package installation
Replies: 11
Views: 2002

I haven't had a use for the 'package installer' since I stopped releasing jobs years ago. Rerunning the installation puts you in 'maintenance' mode and one option there is to just install plug-ins.
by chulett
Mon Feb 05, 2007 7:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Database name included in SQL in ODBC stage
Replies: 7
Views: 2331

Two things can help here: 1) Don't use the 'fully qualified' option when you import the metadata, if available. 2) Don't use the 'Load' option to bring the metadata into the stage. I realize #1 isn't possible with ODBC but some stages do offer that option. However, you should find that while 'Load' ...
by chulett
Mon Feb 05, 2007 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Performance Problem
Replies: 10
Views: 3520

Is there some specific questions I could ask the UNIX dudes? Not really. Explain your situation and have them monitor performance / usage over the course of both runs. That should help narrow down the issue. It could be something like patch levels or a different version of some critical library... ...
by chulett
Mon Feb 05, 2007 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dspackinst - Package installation
Replies: 11
Views: 2002

You know you could rerun the Server installation and have it installed in all projects at once, rather than one by one using dspackinst... yes?

This would also update the 'template' project, such that any new project created after this would also have the plug-in.
by chulett
Sun Feb 04, 2007 8:54 pm
Forum: General
Topic: Looking for Ascential datastage Forum
Replies: 9
Views: 4082

kumar_s wrote:
vmcburney wrote:...never caught on in the US.

No wonder Criag said that.

Well past my teen years as well. And this is one of my social networking sites. :wink:
by chulett
Sun Feb 04, 2007 8:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Store procedure stage
Replies: 17
Views: 4690

how do i get Teradata in the Database vendor list? If you read the STP stage guide, you will see that the vendor section can also be populated during run time by parametrizing it. That doesn't mean you can make up whatever you like as long as you pass it in as a parameter. It means you can pass in ...
by chulett
Sun Feb 04, 2007 8:51 am
Forum: Site/Forum
Topic: Getting logged out during session
Replies: 17
Views: 9495

Haven't seen a burning need, just wondering if that is an issue here. Besides things as noted here I've read many stories about it 'breaking' websites, not because of a fault in IE7 but in the site's design. Here is an unbiased look at the 'issue', if anyone is interested. Figured I'd wait. Hmmm... ...
by chulett
Sun Feb 04, 2007 8:33 am
Forum: General
Topic: Looking for Ascential datastage Forum
Replies: 9
Views: 4082

Never heard of Orkut and got a 'bad server, no doughnut' error when trying to log in with my Google id. The one Ray linked to seems to be different than the one I remember that I think he is referring to, hard to say as it only has 37 posts in it. I was a little appalled to note that one single post...
by chulett
Sat Feb 03, 2007 5:38 pm
Forum: Site/Forum
Topic: Getting logged out during session
Replies: 17
Views: 9495

Odd.. I don't see this issue at all, even when emulating Ray's method which actually is something I do fairly frequently. The only time I see it is when switching 'domains' - from 'www.dsxchange.com' to 'dsxchange.com' (or vice versa, technically) - they seem to require separate logins. If you are u...
by chulett
Sat Feb 03, 2007 2:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL server error
Replies: 2
Views: 893

Seems pretty straight forward. You've got an 'indentity' column which you are passing an explicit value and it's telling you that you need to set IDENTITY_INSERT to ON. Or not pass an explicit value so it can be auto-assigned. If that doesn't make any sense, talk to your DBA. One of many such exampl...
by chulett
Sat Feb 03, 2007 9:33 am
Forum: General
Topic: Looking for Ascential datastage Forum
Replies: 9
Views: 4082

If you are looking for the 'official' forums, the IBM developerWorks are here: m Note that you'll need to sign up and that they are still primarily 'peer' or 'user to user' forums. Sometimes 'Ascential' folks will respond there (it happens here as well) but they are not a replacement for Support.
by chulett
Sat Feb 03, 2007 8:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Equivalent CHAR
Replies: 11
Views: 3265

sylvan_rydes wrote:Well..I have already seen all the posts earlier. Anyway I don't have more to say but thanks for all the feedback.

But... was your question answered? :?
by chulett
Sat Feb 03, 2007 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: pipe function to be implemented
Replies: 2
Views: 706

'In a package'? So, this is in a Stored Procedure that you need to call and one of the (or the only) parameters you need to pass it is this nv_year_month value?

Is there something more to it than using the Stored Procedure stage to call it and pass in whatever value(s) it needs? :?
by chulett
Sat Feb 03, 2007 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Get The status of the job
Replies: 9
Views: 3323

I've never used the "run after job subroutine only if successful" - it rather defeats the purpose to my mind. It certainly would defeat the purpose here which is why I specifically mentioned to not enable it. We have some 'after job' processes where it has been enabled, zipping output files and oth...
by chulett
Fri Feb 02, 2007 10:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Equivalent CHAR
Replies: 11
Views: 3265

:evil: Dang, I can't find the routine Ray posted for the life of me... sorry. It's here somewhere and would be helpful if that is what you are looking for.