DSXchange

IBM offers a service to convert server jobs to parallel jobs, but they still use people to do the bulk of the work. Sure they've built some in-house tools to help them to do that, but the tools are not available outside IBM. If you have documented your server jobs well and have source-to-target mapp...

That particular library (install.liborchteradata) is pertinent to Teradata - it has nothing whatsoever to do with Oracle.

Then ignore my suggestion about Trans() function.

Moderator: please move to Enterprise Edition (parallel) forum

If you're on 64-bit UNIX (e.g. AIX 6.1) or Linux, try unsetting LDR_CNTRL.

Welcome aboard.

I can only suggest search harder. Could it be decimal numbers with rightmost decimal places being truncated?

Perhaps your DBA could enable a higher level of tracing while you solve it.

The DataStage RedBook is here.

I wouldn't bother with step 1 - I'd simply capture a directory listing and process that in a User Variable to produce a delimited list that the Start Loop activity could use. Then you wouldn't need a nested condition either; the "list of things" would contain only the file names that are t...

You neglected to mention whether the message was still there when you restarted DataStage.

Disable operator combination and learn which stage/operator is throwing the error message.

DataStage will not permit a job - other than a multi-instance job with a different invocation ID - to be started if that job's current status is Running. The error code is DSJE.BADSTATE.

In the ten-input Funnel stage, is the size of the VarChar identical on all eleven links?

Have you got a StringToDate() function in a different derivation?

The error message talks about date_from_string, not timestamp_from_string.

Also, you need a timestamp format string that allows for fractional seconds if you wish to keep these.

Generate the parents and children into text files in a staging area. Use another job to load the parents, then another to load the children. It would not be a merge stage, but a link collector stage. But I don't see how you can order the loads in a single job even in a parallel job (unless you're ma...

Your Index() function syntax is good (assuming you have a Then and an Else clause for the If, and that this is an expression in a Transformer stage rather than in Build stage code). Therefore please post any error message; there is not enough information for us to suggest anything more.

Try stopping DataStage, regenerating the shared memory image (uvregen or uv -admin -regen) then restarting DataStage.

If the regeneration reports an error, please post it here, but it basically means that the total size of structures defined in uvconfig is too large.