DSXchange

That would be the DMNS* stage, which was proposed for version 6.1 but never made it through beta.

* DMNS = do what i mean not what I say

I answered the second question, about how to handle the input being a single row. You may need more than one output from a Transformer stage to handle different record types. As to adding data to the output record, you have to tell us where you're getting those other data from, then - and only then ...

Access Violation means an attempt to access a memory location that doesn't belong to the application. This can occur, for example, by trying to put a character string N characters long into a buffer smaller than N characters (e.g. you've used a Char data type). It can also occur when there are unexp...

Presumably, if you're going to read it as a single column, the data type of that column will be a character string of some kind (Char or VarChar).

So you can use substring techniques to split out different substrings from the original string.

For example, YEAR would be InLink.TheColumn[1,4]

OK. If the problem is with a BASIC Transformer stage (as per your subject), then you ARE hitting it every row. But, of course, you're not even getting to process row #1. Yet the log file is telling us that the runLocally() function associated with the operator generated by compiling the BASIC Transf...

Welcome aboard! :D
Run the input through an Aggregator stage, grouping by Column 1 and specifying Last as the aggregate function for the other columns. If the input is sorted, note on the Input link to the Aggregator stage that this is the case; the job will run much more efficiently.

You could invoke your BAT file through ExecDOS as a before/after subroutine. In the Input Values field build a string of job parameters that corresponds to the required command line arguments of the BAT file. For example:

DataStage won't work on UNIX unless $DSHOME/lib is in SHLIB_PATH. The dsenv file guarantees that this is the case.
On Windows shared libraries are found via Registry entries, so that there is no dsenv file required.

Use the operating system (or the BASIC STATUS statement) to examine the date/time modified of the hashed files? Date/time accessed, even.

A search on this Forum is likely to prove productive. For example you will turn up the knowledge that one of the better sources for error codes is the UniVerse InterCall User's Guide.

It might be worth trying the following. 1. Copy VOC, D_VOC, VOCLIB and D_VOCLIB from another project, using operating system command ( cp on UNIX, COPY on Windows). 2. Change to the project directory and enter the dssh environment. . $DSHOME/dsenv $DSHOME/bin/dssh 3. Execute the DataStage command: C...

Reporting Assistant is deprecated in favour of MetaStage from version 7.x.

And please eschew "urgent" - everyone here is a volunteer who posts when possible. If you really want urgent, sign up for high priority 24x7 support, and learn the true cost of "urgent".

If there is a firewall, you ("they") will need to open it to port number 31538, which is the port number on which dsrpcd listens.

You won't, of course, find any information about the ds... executables in UniVerse documentation, though there are uv... equivalents for some of them. dsrpcd is the DataStage RPC daemon, that listens for connection requests from DataStage clients and instantiates the dscs (DataStage common server) f...

I assumed, because it was in the first two lines of your code, that you were specifying @ID FIELD ( TRANS ( RT_LOG109 , //JOB.STARTED.NO , 1 , X ) , ( char ( 252 ) ) , 1 ) as an (the?) expression in the BASIC Transformer. So can you advise what you ARE doing in the BA...