DSXchange

Use @INROWNUM to count the records, stage variables to assemble the XML, and Mod(@INROWNUM,3) = 0 as the output link constraint expression.

This has got nothing at all to do with the query. For whatever reason DataStage (that is, the user ID under which DataStage job executes) is unable to open the file that contains the query.

The best way to think of job ID is as an "alias" for the real job name. As Craig notes, there's no requirement at all to use it, but it's sometimes useful where the real job names are long/unwieldy.

I don't believe that you can share the internal Information Server custom user registry with the operating system, but feel free to try it, at least with one user.

How about you show us what you tried, and tell us in what way you are not "getting exact output"?

Agreed. Use ExecSH as the after-job subroutine, and use mv as the command, with `date +%Y%m%d` as the date part of the file name.

You need a fork-join design. A Copy stage splits your data into two copies. On one stream the data are grouped by customer_ID and the minimum seq_no values are found in an Aggregator stage that follows a Filter stage (or Transformer stage) that only allows "N" values through. The two strea...

The partitioning algorithm can not be seen in the configuration file.

It can be seen in the job design, on the input link of any stage executing in parallel mode.

It can also be seen in the job score.

Get yourself a premium membership so that you can read the whole of my answer, which does cover NVARCHAR data type.

You have also misinterpreted what I said, again (probably) because you can't see the entirety of my post.

So that I understand your requirement correctly, can you please confirm that you're trying to achieve the equivalent of this SQL? SELECT * FROM tablename T1 WHERE T1.seq_no = (SELECT MIN(T2.seq_no) FROM tablename T2 WHERE T1.customer_ID = T2.customer_ID AND T2.orig_Ind = 'N') The solution is likely ...

It's from neither point of view; it's from a METADATA perspective that you have this issue. VARCHAR is your traditional, variable-length character string containing, typically, ASCII characters. NVARCHAR is one way of specifying that the contained data are encoded using something other than a single...

You did not state that in your original questions. I can only read minds at short range. While creating table definitions in the DS_METADATA table is possible, it is not for the faint-hearted. There are 156 columns in this table, but the file dictionary only specifies the first five. The remainder o...

1) There are no standards for paging. What determines how much data goes to each node is the partitioning algorithm. Your scenario (populating only two nodes out of three) might be seen if the data were partitioned using a key-based partitioning algorithm based on a two-valued field, what is classed...

You could slightly modify your process to produce a schema file.

{
Name:string[1];
Address:string[max=80];
City:string[max=80];
}

Is Name really Char(1) data type?

If you have NLS enabled, then 延, 安, 东, 路, 5 and 号 are all printable characters. Perhaps you can use a server job, or a server Transformer stage in a server shared container, or a BASIC Transformer stage, with a routine that checks the result of the UniSeq() function applied to each character in turn...