DSXchange

No, you cannot move a sub-folder. And you don't need to use a 'dummy' name, 'sub-folder' names only need to be unique within a given folder. So just create the new one, move the jobs from old to new then remove the old one.

Don't do DB2, so no clue. Must be an OPEN or BEFORE SQL area, if not perhaps you'd need to do it as separate steps / routines and leverage a sequence job. [shrug]

You'd have to write your own routine for that, build the variables into the mail body and then call the appropriate O/S command directly.

Welcome. :D

I typically use the FMT() function for this, but there are probably other ways as well.

Yup, we load the output into an Oracle table so we can query it.

One way would be to export the project and then manually search the dsx file. Or use a utility like Chuck Smith and others have built to help in the search.

That was some bad advice that was withdrawn. If you are having a problem, please start your own thread on the subject.

You need to read the STP pdf in your Docs directory for what in supports and doesn't support. I think this falls into the latter category.

You only need one or the other, not both:

AND UPCASE(VALUE) = 'XXX'

-or-

AND DOWNCASE(VALUE) = 'xxx'

Jagan617 - can you explain why you think you may need to do this?

Meaning your instance name, userid and password are hard-coded in the stage?

Don't see how.

However, would it still be set once the job's session ends? I guess it would be simple enough to test it.

Get them from whomever controls access to that in your organization then.

You pass it from the WISD stage to an XML capable stage for parsing, and that as one longvarchar field.