DSXchange

Searching DSXchange for the exact keywords "vertical pivot" returned 220 matches! Could you check some of those and if you don't find your answer then you can post your questions to this thread.

Can you delete the routine, if it exists, from the repository before the import then check to see if it has been created after the import? Perhaps the warning references something else.

The is no general best type. The goal is to distribute the rows evenly across the nodes while ensuring that your joins will work. So first priority is to partition on your join keys - this means that such algorithms as round-robin or random don't apply. You will most likely want to hash partition on...

The source code for the routine is at " sdk\Utility" and can be examined in order to understand what it does.

Sainath.Srinivasan wrote:ArndW,

Are you saying that the solution works or not ?

You can try

Code: Select all

std::cerr << "this is a warning message\n";

Yes, I have the std:cout working, but all of the messages I send there end up in a single log entry and I am looking for a method of writing discrete log entries.

Actually, it does work, just as using a PRINT in a before-job of a PX or in a job sequence will put the value in the log. The standard out for informational messages will only issue one log entry per job run, though. I would like my routine to issue one or more distinct warning messages to the log a...

How are you determining the value of "INVALID" in your job? Is it in a transform stage, or a result of a SQL query or some other method? Once that is known, we can help in setting the user status return value.

Change your dataset to a PEEK stage and measure the speed. If it remains slow then you have eliminated the writing portion from the equation.

Approximately how many bytes per row do you have? Is the Sysbase server on the same machien as the DataStage server?

The user status can be used to pass information back to a calling sequence.

How many files are in the new project?

Sainath - could you please explain how this will write the equivalent of DSLogInfo() and DSLogWarn()? I did get output using
but haven't found a way to write a warning message to the log

I've been trying, without success, to write a message (either informational or warning) to the log file of a job calling the buildop. I can't find an example of a c++ call, either. Has anyone actually written a buildop and done this? Which call did you use? All I can find are deprecated definitions ...

that is a bit confusing, since in the job control tab you can call up external programs... which seems to be what you want to do.

login as that user to a shell on the server and "cd" to the project directory and see if a "touch abc" works. I suspect that the user doesn't have create or write access and this is causing your error.

The compile messages are confusing as they refer to a key lookup. Perhaps there is already a token of that name and renaming your "matchRegexp" to "NewmatchRegexp" might change matters?