Search found 53125 matches

by ray.wurlod
Fri Oct 06, 2006 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One or more of your selected locales are not available
Replies: 13
Views: 7316

Hmm. If it were parallel jobs (being C-based) I'd understand, but this one's a bit of a mystery. When you run a job, what is the locale setting reported in the job log? If it's not explicitly reported, examine the second, "environment variables", event in the job run.
by ray.wurlod
Fri Oct 06, 2006 3:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Process Frozen
Replies: 10
Views: 1545

Unless there's an event in the DataStage job log, or you've enabled error logging to the $DSHOME/errlog file, the answer is no.
by ray.wurlod
Fri Oct 06, 2006 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage is having any peoplesoft EPM plugin
Replies: 8
Views: 4721

No. The PeopleSoft PACK consists entirely of server jobs and server job components. You could leverage the table definitions to defined your own parallel jobs, of course, but you'd be re-inventing the wheel, a practice I continually deplore.
by ray.wurlod
Fri Oct 06, 2006 3:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DBF Files
Replies: 10
Views: 2698

Could it be privileges assigned in FoxPro?

Since you get the same symptoms from Access and DataStage, it's clearly not a problem within DataStage.

Is there some other ODBC driver for FoxPro that you might try?
by ray.wurlod
Fri Oct 06, 2006 3:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Process Frozen
Replies: 10
Views: 1545

Well, maybe there was a clash in shared memory. I don't know enough about SQR to be cogent on this. Using START forces a different process to be used.
by ray.wurlod
Fri Oct 06, 2006 3:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One or more of your selected locales are not available
Replies: 13
Views: 7316

If NLS is enabled, all the NLS tabs and command buttons are enabled. Open Administrator client - there's a button on the start page.

Or grep NLS $DSHOME/uvconfig
by ray.wurlod
Fri Oct 06, 2006 3:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One or more of your selected locales are not available
Replies: 13
Views: 7316

This is without NLS installed/enabled?

I've not encountered it before, but I've never played with 7.5.2 on HPUX either. Does support have anything to say?
by ray.wurlod
Fri Oct 06, 2006 3:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: email problem
Replies: 5
Views: 1243

Try it without the commas (only spaces) or with some other delimiter (such as semi-colon). Different SMTP clients seem to have different rules.
by ray.wurlod
Fri Oct 06, 2006 3:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Increasing user limit
Replies: 10
Views: 3293

The 999 licence is what they call an "enterprise" licence. One of my clients was also surprised by this number (but not concerned when I gravely warned that problems will arise when they install their 1000th CPU in the box).
by ray.wurlod
Fri Oct 06, 2006 3:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DBF Files
Replies: 10
Views: 2698

Does the missing table have a space or other special character in its name?

Have you tried checking the "include system tables" box?
by ray.wurlod
Fri Oct 06, 2006 3:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: running datastage job from a datastage routine
Replies: 5
Views: 3242

Short Description Reset a sequence to a given initial value Long Description Using the hashed file SDKSequences (which is created if necessary) this routine resets the sequence whose name is given as its first argument to the value given as its second argument. Returns 0 if successful, otherwise re...
by ray.wurlod
Fri Oct 06, 2006 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: running datastage job from a datastage routine
Replies: 5
Views: 3242

Initialize a stage variable with a function that reads the hashed file. You could use KeyMgtGetNextValue etc., you could use the utility function UtilityHashLookup, you could use the intrinsic Trans() function. Do not provide a derivation for the stage variable. This means that it retains its initia...
by ray.wurlod
Fri Oct 06, 2006 3:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sapces between names
Replies: 5
Views: 1188

Len(MatchField(TrimF(Inlink.TheString), "0A0X0A0X", 2)) will return the number of characters between the first and second group of alphabetic characters. If your words are wholly alphabetic, I think this expression will work for you. It will return 0 if there is on...
by ray.wurlod
Fri Oct 06, 2006 2:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Process Frozen
Replies: 10
Views: 1545

Probably the best advice is to get you to open a cmd shell and there execute the command

Code: Select all

HELP START
by ray.wurlod
Fri Oct 06, 2006 2:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to find a row that exceeds max lenght when reading
Replies: 6
Views: 5679

It would be great if you could find out more from someone there who IS a PROGRESS guy and post the results here. I have a project coming up next year that will involve extraction from a PROGRESS database.