Search found 42189 matches

by chulett
Sat Jun 25, 2005 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job appears not to have started after 60 secs
Replies: 15
Views: 7678

I think if it was T30FILE related you would get a different message. This, as far as I know, is just a sign of an overloaded machine bumping up against a hard-coded limit in the engine. You might want to define what 'multiple' means and describe your server's hardware. See this thread for an example.
by chulett
Fri Jun 24, 2005 9:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in Sequencer
Replies: 6
Views: 1805

:idea: Have you tried to help yourself out? Searching the forum yields several posts with similar messages, perhaps one of them might solve your problem... this one perhaps.
by chulett
Fri Jun 24, 2005 7:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to open the properties page of job activity stage
Replies: 5
Views: 1548

They mispoke - version doesn't matter. If you think you have the SP2 problem, get the patch, it will fix you right up. If that doesn't help, post back and we'll dig deeper.
by chulett
Fri Jun 24, 2005 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Manager Export/Import
Replies: 3
Views: 1110

Or, as a way to check that you've got everything you need to support the jobs in the other Project, actually compile them there. The 'quick' way is to use the Multiple Job Compiler found in the Manager, it will run through and compile them all for you.
by chulett
Thu Jun 23, 2005 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job cntroller is not sending the parameter to attached job
Replies: 14
Views: 4283

Well, then at this point something about your assumptions is incorrect or it would be working... and we've done all we can to point you in the right direction. Double-check everything about that parameter and how you are setting it. Have someone else check, it's amazing what another pair of eyes wil...
by chulett
Thu Jun 23, 2005 7:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job cntroller is not sending the parameter to attached job
Replies: 14
Views: 4283

Doesn't matter what you 'expect' it to be, what is the exact value you are attempting to set it to when it fails? Write sumFile1 to your log file first so you know.
by chulett
Thu Jun 23, 2005 7:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job cntroller is not sending the parameter to attached job
Replies: 14
Views: 4283

Have you looked up what an error code of 4 means? It equates to DSJE.BADVALUE and means "Parameter Value is not appropriate for that parameter type".

So... what type do you have the parameter defined as and what value are you trying to set it to?
by chulett
Thu Jun 23, 2005 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Add transaction feature to sql statement
Replies: 3
Views: 1210

:? Stupid stage. Can you tell I hardly ever use it? :lol:

What about the Informix stage, does it support that concept? Without that, I'm afraid the OP would be out of luck unless there is a different answer to the problem other than having to set the lock mode.
by chulett
Thu Jun 23, 2005 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Add transaction feature to sql statement
Replies: 3
Views: 1210

In the 'Before SQL' tab of the stage.
by chulett
Thu Jun 23, 2005 6:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why Rnd() function generates same number twice?
Replies: 10
Views: 2965

You aren't doing all of this to generate a surrogate key, are you? :?
by chulett
Thu Jun 23, 2005 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to clean up a file through server routine?
Replies: 18
Views: 3133

And the square brackets that sorta make it look like it might be a function are just the substring operator.
by chulett
Thu Jun 23, 2005 6:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: '£ ' getting converted to '#'
Replies: 6
Views: 2604

Hash, or "hash sign" or "hash mark". I know... was just kidding. When I am trying to use NVarchar i get the following error: ' Stage does not support UNICODE character set' True, the OCI stage does not. The DRS stage probably throws the same error when set to Oracle but what about when you set it t...
by chulett
Wed Jun 22, 2005 7:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: '£ ' getting converted to '#'
Replies: 6
Views: 2604

What do you call it, Ray... Hash? Square? Sharp? Shibboleth? :wink:
by chulett
Wed Jun 22, 2005 7:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Runing On Several Tables
Replies: 7
Views: 1264

Besides, why make it more complicated than it needs to be? What's wrong with scripting something to execute the sp and triggering that inside your Sequencer job via a Routine Activity? :?
by chulett
Wed Jun 22, 2005 7:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: shell script
Replies: 7
Views: 3361

I was going to say - that is the sample. You did click on the link, did you not?