DSXchange

Is your source table in fact partitioned? Note that index <> partition, you seem to be confusing the two. Check with your DBA if you are unsure.

Typically that means that it was already running when the Sequence tried to run it.

Cracked me up the first time I saw someone use that URL elsewhere, been waiting for a good chance to leverage it here.

From what I've seen here, the dssearch command can be used for that.

From what I've seen here, the dssearch command can be used for that.

First, define "excel file" - .xls or .csv? And are they "stripped off" in the file you generated or after loading the file into Excel?

1) A window pops up to overwrite the file - the file doesn't exist but even if it does - I don't want the Popup window. Is there an extra switch that I need to add to the command to overwrite the file? This happens when your default (i.e. the last one performed) component export file type is set to...

While you cannot use DB2 8.2 for your common metadata repository, you certainly should be able to connect to it from your jobs. You just need to configure things properly. And you proceed by reading the documentation on the subject, that or contacting your official support provider so they can walk ...

Yah, thanks Ray... for the lame joke. :wink: The output link doesn't "do nothing", it allows an OK trigger from the previous stage to exist that otherwise wouldn't have one and this makes the Sequence Job restartable from that last Job Activity stage if that job aborts and you have those o...

Actually, it may not be the answer you wanted but it *is* your answer. There's no 'command line' to do this and you already noted the restrictions in your 'Additional Info'. You'll need to use the Director for the order by portion and then cherry-pick those that match your criteria to move from the ...

Any chance the table name you used in the stage is longer than 30 characters?

Actually there is, the same one you mentioned: dsjob -run -warn 0 Here zero equals unlimited as well. Usually a Bad Idea but that's how you would do it.

Search for "return code 141", it's been discussed here before.

Here ya go: http://tinyurl.com/cg3rga

Hey Lance! [waves] :D Well... technically, in the 'after job' part of things the job hasn't actually finished yet. There you need to check for the JOBINTERIMSTATUS which is what it will be when the job ends assuming your after job routine doesn't blow up, otherwise I think you will get what it was f...