DSXchange

Why not just call the UNIX command from a command stage, then refer to the result in your user variable activity stage.

Stage variables cannot be set to null. Is "CODE1" a stage variable?

Allow reject in the DB2 stage and put the reject link out to a peek stage to find out why it is being rejected. If no rejects, then check for your unique primary key - what column(s) are used?

Just delete the "Record Delimiter" completely. You are seeing the difference between a UNIX and DOS line termination, <CR>LF> versus <LF>.

sequential file stage.

There is no UNIX command to do this, but you can set the autopurge settings to automatically do this for you.

Does the derivation "Upcase(In.Character)=In.Character" for this character equate to 1 or 0?

The only way that 100 rows going into a transform won't generate 100 rows for each and every output link is if you use constraints (or have errors). So we need to know what constraints you have used.

The messages you posted are for a lookup stage, yet your are talking about a transform stage. Ignoring your lookup stage issues, the transform stage limits output only in the constraints, so please post your constraints and whether or not you have activated the "otherwise" box for any of them.

If you do as Ray suggests you will need to increase BigCol to hold more than 25 charactes.
The "Final Delimiter" is not the same as the "Line delimiter"

I don't think that FTP can be used in the way that you think. There are 2 approaches to this - either you have a job running that waits for an event to happen and then starts processing, or you use dsjob.exe on the remote machine where the event happens to start the processing on the DS server. Both...

you can install dsrun.exe on any machine which can "see" (in TCPIP terms) the DS server. You can check up the syntax for dsrun.exe in the documentation, but using the program you can start a job on the DS server; so if you write a script or .BAT program in Windows it can automatically start a remote...

It is much simpler to call the dsjob.exe program and start the job directly.

What happened to the mandatory 2nd "ELSE"?

Ok, that can be done. Keep your input file definitions as they are. If I recall correctly, 0x0a is "whitespace" in XML, so you could add a transform stage: SvarNewLine = IF INDEX(In.BigColumn,'>',1) > 0 THEN 1 ELSE 0 SvarOutString = IF SvarNewLine=1 THEN SvarDataString:In.BigColumn ELSE '' S...