DSXchange

Vector is not a data type. You have a vector of integers, for example.
Vectors and subrecords are managed in the extended properties of the column. Double click the row number in the Columns grid to open the dialog where these are edited (in the bottom left-hand corner).

Have you named two sequential files in the Merge stage?

Question: what is the scope of stage variables? Are they available in before-stage or after-stage subroutines or only in the body of stage processing? To put it another way, what happens first - execution of the before-stage subroutine or initialization of the stage variables? Have a think about tha...

You can't - and don't have to - use $PROJDEF on the dsjob command line. What you do is set the default value (in the design) to $PROJDEF then, if that's what you want to use, simply omit that particular -param argument from the dsjob command line.

floor means "next lower". In negative numbers, next lower is closer to negative infinity. You need a different strategy - round the absolute value then multiply by -1 if the original was negative.

Advanced Parallel Job Developer's Guide chapter on custom stage types.

Don't you need the maximum expiry date for each CUSTNUM, ZH41N combination? This would need more conditions in the where clause, turning the query into a correlated subquery.

Probably, but what is "1x10"?

Try providing a maximum length for each VarChar column. "Unbounded" means that there is at least one VarChar that does not have a maximum length in your metadata.

On Windows there is no .odbc.ini file (though the Registry key is called ODBC.INI).

If it were a job sequence you could use exactly that expression.

In dsjob you have to do what you can do in UNIX. Something like

Arnd's question is still relevant, assuming you really do have Information Analyzer. Without an answer to it, it's really impossibly to advise.

But it would be better to have the edition properly identified. It's not 390.

Yes, and support will take you through the process of where (whence) and what they want gathered.

One of the functions available in the Aggregator stage is First. Another is Last. Thus you don't need max. If your filenames are sorted just choose the first or last of them.

Not in version 7.

Can you please check that the dsrpcd process is running on the server? (Although I would expect a different error code if it were not running.)

Can you try re-booting your client machine?