DSXchange

Or...


And you want one row, not 'at least one', unless you want to (possibly) run the proc multiple times.

In other words, only if you are running a Windows Server AND you have the client components installed on that same server. And it doesn't change the fact that you are running client utilities, not server utilities.

Let's not muddy the water, peoples.

No, it's not difficult. Add that Environment Variable using the Administrator and set it to $ENV. Then add it to the job and override the value to be what you need in this job. Or set it (NLS_SORT) up as BINARY or CANADIAN FRENCH in the Administrator if you want it to be automagically applied global...

These utilities exist only on the client side. Why? Ask Ascential / IBM. [shrug]

All 32 bit operating systems have that limitation on physical memory.

Nice article but it doesn't address the specific 'dsjob' question that I noticed. However, it does make me realize that the OP doesn't really seem to have things setup correctly. The value of the variable should either already be defined in the 'environment' (in dsenv, for example) and then set in t...

From the UNIX server? Not possible.

Have you looked in the directory see see what is (or isn't) there for this particular hashed file? I would guess that parts are there and parts aren't. Try unchecking the 'Clear' option and enabling the 'Delete' option under the 'Create' button.

No such beastie. Exports are client side only.

By using the Trigger Column as noted. It doesn't need to be used in the XML, just exist on the link feeding the XML Output stage. Then code (in a Transformer, for example) for it to change every 60000 records. Perhaps a mod() or a simple if-then-else bit of logic to increment it based on @OUTROWNUM....

It is present only in the XML Output stage as it is the only one actually producing XML. And recognize the fact that it would be driven by the number of records going into the stage, not any kind of output record length. You seem to be using the two concepts interchangeably... it confuseth me.

Sure.... sorta. Searching for something like 'server export' (all terms) should turn up multiple conversations on this topic, including for examplethis one. What you'll also find is that this needs to happen from the client, not the server.

Do you know the specific client version? For example, 9iR2 could be:

9.2.0.1
9.2.0.5
9.2.0.8

Etc. Support should have asked the same question, I would think. Anywho, let us know if you have any luck.

Suggest... patience.

No, just trying to specify what the 'Derivation' of the stage variable should be in the Transformer - i.e. how the value is set. ps. If the PX Transformer works anything like the Server version, there's a button inside it to 'Show/Hide Stage Variables' which defaults to 'Hide'. Make sure it is set t...