DSXchange

There's no sense of "special" characters here. You want to keep the numeric characters and convert all non-numeric characters to zero. svNonNumerics <== Convert("0123456789","",InLink.TheString) Convert(svNonNumerics,Str("0",Len(svNonNumerics)),InLink.TheStrin...

Looks like this can happen when you use "CopyOf..." stage names (? and sequential mode specified). Not totally sure how.

What stage types are you using? Assuming you are using an XML Input stage, what xml-path values are you using?

What's "09"? Is your timestamp in the expected format, correctly quoted, etc.? It seems you're getting fairly close.

The header and trailer records are probably not being imported successfully because they do not match the metadata (record schema) of the detail lines. Your job log should show the number of records imported successfully. A reject link from the sequential file stage would allow you to capture any ro...

Examine the score. Which operator is op1? Does it specify any node pool or disk pool constraint?

The "-CS" maps are only intended to be used between the DataStage server and the DataStage client (for example with View Data). Try specifying the equivalent non "-CS" map (for example MS1252) in your job.

$ReturnValue can include a line terminator that is translated to a DataStage "field mark". Are you aware of the fact that you may need to ignore this character - or, perhaps, more than one, depending on the actual command?

This error message is in the client software. Typically re-booting the client machine is sufficient to eliminate it.

So, no "clever way" then?

Check that step #3 actually succeeded.

Hiding behind Santa Claus, Craig posted #30000 today. #30001 too!

You probably need to increase available memory or, if that's not possible, scratch space. The Sort stage allows you to allocate memory for that stage alone, while a global change may be wrought via the APT_TSORT_STRESS_BLOCKSIZE environment variable.

You have marked this thread as Resolved. Please advise HOW it was resolved, to aid future searchers.

My first guess is that the installation was not successful, in that (at least) it has failed to install the Oracle Connector stage type. Check your install log.

Are any other stage types missing? Check Repository (stage types branch) in Designer.