DSXchange

vij wrote:In the same job, I want this target as a source and load another dataset.

Is it not possible to do it in a single job?

No. "Blocking" operations such as this are specifically prohibited in parallel jobs, as they prevent pipeline parallelism from occurring.

You can use Oracle functions or you can use DataStage.
If you use DataStage you will need either a (parallel) routine or a calendar table to determine which days are weekends. This is particularly true if your requirement extends the definition of "weekend" to include "holiday".

Or, if you don't want to convert the data type of the column, you need some other VarChar, such as a stage variable or an intermediate result in an expression that you can use to effect the Trim operation. For example dec_field:decimal[10,0] = decimal_from_string(string_trim[' ',end,begin](c...

You need to understand how the Lookup stage works, possibly by inspecting the score (specify APT_DUMP_SCORE as True). A Lookup stage generates a composite operator; it performs two operations. The first is to load the reference source into a virtual Data Set (120 rows in your case, loaded from the C...

Not inadvertently - it's all DataStage could do given your design, which is asking DataStage potentially to stuff a 50 character string into a 20 character field. Of course it's going to generate a warning - you can lose information by trying to do this! The alternative would be to abort the job. Yo...

Yes I agree with you, but I am facing a weird condition..when try to compile a job using a transformer then it is throwing error but removing the transfor fer,I can perform the compilation...why it is happening? Only Transformer and BuildOp stages require the C++ compiler. A job design containing n...

But Sequential File stage in parallel jobs can have multiple File properties or a read method of File Pattern. Either of these can read multiple files. An XSLT error usually indicates some incompatibility with the content of the XML file and the style sheet that you have specified as containing the ...

The DATE() and TIME() functions refer to the system clock; they will increment over the run time of your job. To get the job start time you can prefer the system variables @DATE and @TIME in such an expression. Oconv(@DATE, "D-YMD[4,2,2]") : " " : Oconv(@TIME, "M...

They are all (almost all) documented, but only indirectly. For each of the DataStage API functions there is a list of possible returned values, which is where these constants are mentioned. You can obtain their decoded values from JOBCONTROL.H but, since they are almost all integers, this does not a...

The word "instance" can be misleading in this help. It is actually the row count from each partition . The partitions are in the same order that they are specified in the configuration file (possibly moderated by execution of the stage in a node pool, but the order remains that from the configuratio...

There is a script called something like DSEresetperms in the DSEngine directory (in one of its subdirectories) that you may find a simpler solution. Some of the executables, in $DSHOME/bin particularly, have very specific permissions requirements - they must have the setuid bit set and be owned by r...

There is primitive help in the Hashed File Calculator - it all pops up in message boxes. However, the help is about how to use the tool, rather than about the underlying calculations. Otherwise you need to consult the UniVerse manuals. The important measure is the number of bytes per record. In your...

With suitable instructions they could be tasked with freeing locks on job designs that result from connections becoming defunct and the like. That would provide feedback as to the frequency of occurrence, and visibility of any pattern that might be emerging (for example particular users). Regular ex...

View that message handler file (in the MessageHandlers directory) to see whether the particular event ID is stored therein as you requested.

What - precisely - did you attempt?

Which of the three option buttons did you select?