DSXchange

Accidentally? As a matter of fact...

viewtopic.php?t=106690

:D

Sorry, but I can't explain the behaviour you saw. I use the ROWNUM variables "all the time" and have never seeing this issue. Have you opened a case with your official support provider? What exact 7.x version do you have and on what UNIX platform? If it's earlier than 7.5.1a then the answe...

Stage variable using "+". SDK routine "RowProcRunningTotal". Or an Aggregator stage.

Sorry, but it's my choice when I post "Premium" comments and when I don't. What "logic change" did you make that made it work - from what to what, precisely?

SeqActJobs..JobControl (@EXC_Read_Seq_AcCode): Executed: sh -c /ajserver/inputs/docs_in/cat LKP_ACTCODE Reply=127 Output from command ====> LKP_ACTCODE: /ajserver/inputs/docs_in/cat: not found SeqActJobs..JobControl (@EXC_Read_Seq_AcCode): Command sh -c did not finish OK, reply = '127' You did noti...

Be aware of what it is doing - getting a list of job numbers and issuing a CLEAR.FILE for each one in a loop, which means you'll lose all of your auto purge information. However, there is another Ken Bland utility out there to set them all as well. Not 'preserve' but set.

You 'changed the job' how? From what design to what design?

Isn't there an environment variable that you can set to "fix" this behaviour with the file pattern & filenamecolumn?

From the command line you specify the invocation id as part of the jobname with a 'dot' separator. So a MI job named 'Fred' with an Invocation ID of 'blah' would be referred to as 'Fred.blah'.

Absolutely - those trigger expression need to be on the triggers from the Execute Command stage to each Job Activity stage, the triggers from there to the Sequencer should all be "OK" triggers. Double-check the log entry for the Execute Command stage, post the contents of that log entry so...

The ODBC and UV stages are the only ones that support that option.

I've explained in the thread about my design. No, you explained nothing about your job design, just stated you had a problem without providing any details. For example, do you have any kind of buffering enabled in your job? Did you post a list of the stages used or details of the transformations be...

Didn't answer my install question re: location.

The admin user designation is part of the client install?

They are just regular 'users' created on your server outside of DataStage that it uses to authenticate you. Most organizations have dedicated people that would do that for you, regular folk don't run around creating users.