DSXchange

Right, so either desc or DESC but not mixed case.

There's no such role in the 7.x release that I am aware of, but one in 8.x (Super Operator?) may come close. If they can monitor, they can run... unless perhaps you play games with the underlying permissions?

You can edit your own posts.

You don't use the FTP stage to issue an ftp command, it is all metadata driven and streaming. If you want to execute the command, script it and run the script after job as you have done. In the job I would read the file as one long fixed width field of 100 characters and run it through the FTP stage...

The two biggest things to know are: 1. Never leave the Temporary Directory empty as that puts all work files in the Project 2. How to enter the Sort Specifications The sort specs are simply a column separated list of the columns to sort on (in that order) and the 'direction' to sort: Column_A asc, C...

The two biggest things to know are: 1. Never leave the Temporary Directory empty as that puts all work files in the Project 2. How to enter the Sort Specifications The sort specs are simply a column separated list of the columns to sort on (in that order) and the 'direction' to sort: Column_A asc, C...

Meaning you didn't understand the help or couldn't find any help for the stage?

Well, that role is fairly useless. It requires the jobs to be 'Released' to be seen and that process is well and truly (and thankfully) obsolete. What are you trying to accomplish with this role?

That's true.

I personally don't know but don't you have a DBA you could ask?

They run as if they were two separate jobs.

Through the dssh shell command. A search for 'dssh' (or the older 'uvsh') should turn up a number of examples.

What do you mean it "didn't work"? Removing it should allow everything written to 'the screen' to be captured in the log. It wasn't meant to fix anything but rather give you an idea what needed to be fixed.

First off, stop 'piping cats' as they say. The "wc" function works just fine by itself without having to cat a file to it. Secondly put something in the script to help you debug the issue, either specific echoes or use the "xtrace" option of the shell. #!/bin/ksh set -o xtrace filename=${1}...

Are the 'missing' jobs listed in the Dependancies tab of the Sequence job that runs them?