DSXchange

1. Probably not true. Where was this "somewhere"? 2. There are literally hundreds of commands for adding entries to the VOC file. The correct one depends on precisely what you want to achieve. Visit the IBM UniVerse manuals website and begin by reading UniVerse System Description then UniVerse User ...

Enrol in the class (code DX437) Administering DataStage, if this question really pertains to parallel jobs. You posted in the parallel forum, but marked your job as "server". Research the dsjob command in either the Server Job Developer's Guide or the Parallel Job Advanced Developer's Guide - the se...

If there are no double-quote characters in the data, then use a Filter command to get rid of them. The tr -d \" command would be fairly efficient. You could also set the Quote Character property to None, which would mean that the quote characters become ordinary data, but could be removed subsequent...

That's about 4000 rows/second which, if you believe this is a valid metric, isn't all that bad.

You could try separating the operations. Use direct write (bulk load) for the inserts, then upsert (with "Update Only" as the rule) for the updates.

A dynamic hashed file is implemented as a directory containing precisely three files, called DATA.30, OVER.30 and .Type30.

DO NOT OPEN THESE INDIVIDUAL FILES

Any attempt to do so risks terminal corruption of the hashed file. You will get neither sympathy nor support if you do.

Even if they could, there's nothing you could do about it. It's a CALL statement to an internal subroutine, and it's passing the just-extracted Transformer stage name, so presumably it's something to do with reporting. Only Advanced Technical Support could determine for sure - even first line suppor...

Welcome aboard.

Procedural Note
We do not hijack threads. For a new topic, we start a new thread.
Please do so.

Study the chapter in Parallel Job Developer's Guide on the Oracle Enterprise, study also chapters 2 and 3. Trawl through the on-line help too. As you noted, in the Oracle Enterprise stage type all you get is sqlcode on the reject link (plus all the columns from the input link, of course). It's not t...

The sys... tables are queried by the Oracle Enterprise stage to determine whether, and if so how, the table is partitioned. This error can arise if you lack any privileges at all to these tables. Get your DBA to grant SELECT privilege to the eight system tables that the Oracle Enterprise stage might...

OK, in spite of your tr not behaving like the man pages say it ought, try this:

If that doesn't work, try using Ctrl-@, shown as ^@ below.

I presume you mean Cleanup Resources to log out the other user. This is a clean logout, but may take some time to complete. For safety, it is better to release all the locks owned by that process in the client before logging the process out. Then wait 2-4 minutes for the system to "clean up".

You're right - it's very simple. But the API doesn't help if you're going to rely on osh. Further, I don't think you'll get any performance gains - after all, the osh is simply two operators - import followed by copy. Build the job and examine the generated OSH.

Pre-sort by Id then by Status. That having been done, you can use stage variables in a Transformer stage to detect change, and Iconv() of the date(s) - which you can "remember" also using stage variables - to calculate the days difference.

Try losing the hard quotes, and using the -d option.

You are missing the point. You can not pass $PROJDEF as a job parameter. This is a special token (as is $ENV or $UNSET) that can be used as the default value for otherwise-named environment variable job parameters. For example, you can add the environment variable value $APT_CONFIG_FILE as a job par...