DSXchange

What is the BASIC Transformer doing?

It's not necessarily that the problem is the stage; something has killed a process on node #0. This may simply be that the machine was overloaded at the time. Are there any other messages in the job log about "kill" or similar?

It's not logged, unless you change the start up script to have dsrpcd do minimal logging (-d1 on its command line and redirect output to a log file rather than to /dev/null).

DS.TOOLS however is not a UniVerse command. It's merely a menu that allows certain administrative tasks to be performed on the server side; mostly the tasks that are performed from Director client relating to showing and cleaning up resources. As far as I can tell, DS.TOOLS is not documented in any ...

And you were so joyful that you marked the thread as Resolved!

And the requirement is to use DataStage TX maps?

Your confidence is misplaced, based on what the "job started" event reported.

Search the forum for techniques for posting images to a free image server and linking to it from here.

Can't help you without knowing what error message was returned. There's nothing visibly wrong with your SELECT statement (WHERE is definitely OK). Beware case sensitivity in identifier names (table names, column names). Post a (partial) listing of the file dictionary. ... try SELECT COUNT(*),1,1 ......

You've marked this as resolved. What were you missing?

You are correct, Data Set files are "internal format" which means that numeric values are stored in binary form and variable-length character strings have a length number (number of bytes specified in the record schema) ahead of the actual character string. If you want external format you need to pr...

Something is not right here - it is obvious that the values are not being assigned in the Job activity.

Open the job properties of the job sequence and inspect the generated code to see whether you can spot anything in the code. If possible can you post an image of the Job activity's Job tab?

(1) Through a call to the SDK Key Management functions (which effectively implement sequences for DataStage). (2) You could only achieve this using your own job control routine. It would need to check all currently-running instances ( DSGetJobInfo(hJob, DSJ.JOBINVOCATIONS) ) and the file name/path a...

Welcome aboard. :D You may have more luck posting this question on the forum dedicated to questions and answers about parallel jobs - maybe not all of the folks there read the General forum. What exact version of DataStage are you using? While versions from 6.0 onwards will let you design DataStage ...

$INCLUDE DSINCLUDE DSD_STAGE.H $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSD.H $INCLUDE DSINCLUDE DSD_RTSTATUS.H * Change this line to enable logging of messages $UNDEFINE TESTMODE Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" * Passing JobName for which ...

If you have only one Routine activity you can only call UtilityHashLookup once. How are you establishing values for the User Variables? How are you propagating these within the Job activity - that is, how are you filling in the job parameters grid for the job? And please verify, from the "job starti...

Modify the routine code so that it does not emit the messages to the log.

Or you can make these statements conditionally compiled (using $DEFINE, $IFDEF and so on) so that they can be left in the source code but ignored by the compiler.