DSXchange

Note that this is now a "from the command prompt" issue and is not something you'll need to do for the Execute Command stage. You will, however, still need to resolve your PATH issue there.

Perhaps the csplit UNIX command could be helpful here.

Basically, it's just doing a sorted read of the job's log. Is it especially... large? Can you view it in its entirety via the Director? How long before you decided it was 'hung'?

Thanks but nothing is helping so I'll just post the same error again? :? SH: dsjob: not found The SHell cannot find the 'dsjob' command. This is because, as Ray noted, its home directory is not in your PATH environment variable. One option to 'fix' that is to fully path the command, as I noted. This...

Something wrong with your original post asking this rather sparse question?

viewtopic.php?t=133212

If you still need help with this, continue any conversation on this topic over there.

How are you trying to 'read' this file in that stage? What do the contents of the file actually look like? One or many records? Sometimes a simple 'cat' is all it takes, hence the questions.

Possible second word: full

If that still doesn't work, probably leading spaces are biting you:

Trim(Field(Execute_Command_45.$CommandOutput," ",1,1))

Start simple, what does Field(Execute_Command_45.$CommandOutput," ",1,1) return?

Do an exact search for "Failed opening fifo", they all seem to be DB2 related. See if any of them help.

What have you tried? Where do you want to do this - a shell script using dsjob? Some other form of job control code, DataStage BASIC perhaps?

Strange, though, how the View Data error happens while running the job.

Introducing a new column is fine, there's no need to include it in the output XML. And just make sure the value changes at the appropriate record count, everything else is automatic. Stage variables in a transformer would probably be the easiest approach, either by resetting a current file counter t...

Use the Trigger Column option with a column that changes value every .5M records.

First let us know what "process" means, what do you actually have to do with this data? And what is your target?