DSXchange

Same as DSJ.JOBSTATUS in DSGetJobInfo, some of which you will find in Help, the remainder in JOBCONTROL.H (in DSINCLUDE) or by searching this forum.

As I said, "you can take that Char column and direct it across a Transformer stage into a VarChar with no derivation expression other than the input column". There is no error. There is no CAST required.

The Funnel stage is really UNION ALL. If you want just UNION, follow the Funnel stage with a Remove Duplicates stage.

What are the Oracle data types for col1 and col2?

It IS the same in DataStage. However the metadata in your DataStage job design are used to communicate with the database server, which is the origin of your metadata mismatch warnings. But you can take that Char column and direct it across a Transformer stage into a VarChar with no derivation expres...

May I suggest SQL instaad? RetrieVe has to write a temporary entry to the file dictionary (DICT VOC in your case). UniVerse SQL does not require write permission to the dictionary because it doesn't write anything there. MathExpression= '1+2+3+4=9' Command = "SELECT EVAL " : DQuote(Mat...

But the error is "requires a minimum of '1' stream outputs". Does the menu show a "Convert to Stream" option?

Hacking the Repository works if you know/understand what you are doing, but is not to be recommended in general. What you've done in the current version can not be guaranteed to work in the next version, as "they" reserve the right to change the structures and regularly do. How did you get the metad...

Is the link between the Sequential File stage and the DB2 Enterprise stage a solid line or a dashed line? If it is a dashed line this means that it is a reference or reject link. You need to select the link, right click, and choose "Convert to Stream" from the menu.

Find where gdb is and make sure that its parent directory is in the PATH.

Only that you have no spare capacity to do anything else at the time.

If you don't want to do anything else at the time, this is not a problem. Faster CPUs would allow you to get through the work faster, given that your current hardware has no idle capacity.

Have you read Chapter 2 of the Parallel Job Developer's Guide yet? That should answer this and any related questions. You may also find Chapter 58 edifying, as it goes into many examples of how to construct a configuration file, and therefore contains a wealth of information about processing nodes, ...

Someone DID issue a kill -9 command, Madhu, but probably won't admit to it. This is the only way that this particular signal can be generated. No-one creates applications or scripts to use this command, it's just too dangerous. For example, take a look at $DSHOME/sample/ds.rc (the DataStage startup/...

When I did the training for version 1.0 (which was VERY slow), the instructor set us a task for a prize; the winner had to create the job that finished in the least possible time, as measured in Director. My job finished in half the time of everyone else's. 7 minutes against their 15 and more. I got...

Care to share your solution, in case someone else has the same requirement?