DSXchange

Log out the Designer session and wait. The lock will be cleaned up after a short while (maybe as long as 15 minutes).

What do you infer from the first "paragraph" of the error message? Everything you need to diagnose this one is there.

The specification was that "only one country will be processed at a time".

While that does not invalidate your design, you've over-fulfilled the requirement.

You cannot make any change without naming the column involved. That does not preclude you from using RCP for other columns, of course. If the data type change can be implicit, then a Copy stage is the simplest solution. If you want a more generic design, make use of the fact that a specification in ...

When diagnosing look on both sides of where the error is actually reported.

Even if the job is multi-instance it can be called from different Job activities with different invocation IDs - possibly the country.

Seems to me the heart of your problem is

A '<' character cannot be used in attribute 'xmlns:ns2', except through <

That's why I took the approach that I described (it works in both server and parallel jobs).

If you have an ODBC driver for QC, then the ODBC Connector stage would be favourite. If not, then you probably have to either create your own stage, or have the database dump data in some flat file format that you can read with Sequential File stage.

Only ever one country, or possibly both? Either way you set up parameter(s) in the sequence to specify which country/countries, and use trigger expressions - possibly in Nested Condition activities - to specify what is to occur. Is there any dependency (for example country A2 runs only after country...

No.

By default encrypt uses AES-128 encryption. With the kind of hardware DataStage runs on, you'd need centuries to crack these.

You need to test this within the loop, or construct a list based on the status before entering the loop.

Have the server job place the value into its User Status area. In the sequence refer to the activity variable $UserStatus (for the activity that runs the server job) to get that value. This can appear directly in any field that can contain an expression and which is downstream of the server job acti...

I thought you might have worked "Spamalot" into the thread somewhere there, Craig.

Especially as it's playing in Denver (Buell Theater) next week.
http://www.denvercenter.org/buy-tickets ... about.aspx

Another possibility is that you have a 32-bit unzip utility on your Engine. To unzip more than 2GB you require a 64-bit-capable unzip utility.