DSXchange

Did you check whether you have enough space in the file system?

What is the file size when it aborts?

As ArndW suggested, you can use dsjob with logsum or other options you think will be useful. Alternatively you can read from the log object itself. Otherwise you can

The first option is simplest.

Is there a before job stage?

Is it a multi-instance job?

Did you try rebuilding your project index?

Did you try passing the column to break alone?

If nothing works, bounce DS server.

You can use DS to extract the rows from the dbms rather than landing in a seq file.

As Ray has pointed out, your ulimit in DataStage is set to 2Gb.

You need to
1.) Change your Unix ulimit
2.) Bounce DataStage

If you run your job after this, it must work fine.

From what you said earlier, it does seem that your ds environment ulimit is set to unlimited. But as policy of AIX, you may have limitations creating files more than 2Gb. You can attempt to create a file for more than 2 Gb outside DataStage. This will give you an idea of whether the limitation is wi...

Are you working with AIX?

What is the file size? Is it zero bytes? Maybe the file shrinked after the error

So can you run the job again and monitor the file size in background.

In transform, you can do
If <condition> Then If <Condition> Then <Stmt1> Else <Stmt2> Else <Stmt3>

If you want multiple statements, then you need to go to routines.

In Unix level, yes.

In a transformer you can only use an inline if statement. So it cannot be multiple lines. But you can have multiple if.

What I meant for is that if you have the link ticked for reject passed into an IPC stage, then you will not receive the warning message even if any records are passed through it.

The Date OConv must have a trim for '-' as otherwise you will get YYYY-MM-DD.

Are you running the job part of a sequencer or batch control? If so, you need to define a variable to the file named prepared part of the step.

The $fn will not return the desired result. You may have to call from Job control or sequencer or OS.