DSXchange

First, confirm that you are strictly using the Version Control software (and nothing else) for this promotion activity. I ask because of the terminology you are using. Export and Import are Administrator verbs, while the equivalent VC steps are 'Initialize' and 'Promote'. Also, during the Promotion ...

Apparently, that was all it took to answer the question. In case you want to discuss this more, you'll need to supply some of those pesky 'detail' things we would need to help. You've made no mention of what kind of 'transformations' you are making. Simple answer would be to use other stages - a tra...

I would assume because they just don't work. From the docs:

You can only use Server Shared Containers in this way on SMP systems (not MPP or cluster systems).

Others may know the gory details of the 'why'. [shrug] Or ask IBM.

Ok, that gets us started. So, this discussion is in regard to #3, yes? Why not simply pass the Oracle information in as Job Parameters? That way, even 'encrypted', they can be passed to your After Job process without issue. I would also think, if you are reading 'encrypted' values from a file, that ...

First - what exactly are you doing in this 'shell script encapsulated in a routine that does something in Oracle via sqlplus' (I assume)? Any particular reason you felt you needed to do it this way?

Never had to do anything like that. Have you tried declaring them as 30 character varchars and basically emulating your SQL example?

Not a DataStage version issue or an Oracle version issue, per se, I would think. Probably just a matter of Oracle differences between the two 'identical' instances, and could very well be the case even if both were 8i. Volumes, statistics, and histograms differences between the two could contribute ...

True... it really depends on a number of different things. In this particular case, the 'Missing Column' attribute is key. Sorry, I'd just gone over this with our production support folks for one particular job so it was fresh in my head, but the circumstances there were a little different. It was a...

Actually, it depends on your Warning Limit for the run. It will log a warning and the job will continue unless the number of warnings exceeds your threshold, then it will abort.

kamal kishore wrote:Is it necessary to install C++ explicitly, we havnt installed C++ explicitly.

Yes, installed and configured correctly. It is needed once the Transformer stage in introduced into a job. Before that, no.

Ok, I see... you are looking at the Oracle 7 Load stage. That's an important distinction to make, my friend. Besides the fact that it is for Oracle 7, I don't think that stage is even documented anywhere, at least not anywhere I could find. And from what I recall is painful to get working. It may 'w...

Unfortunately, you can't because I've replied to it. Don't worry about it, just pick up the conversation over in the EE forum.

Ok... I've explored it and found two choices: Manual and Automatic. Please explain how either of them directly allow this problem to be solved.

Other than the manual 'Manual' method I've already mentioned, that is.

Or maybe just "Me too!".

And I just noticed that you posted in the wrong forum. This one is specifically for RTI issues. If you want to pursue this, I'd suggest posting in the correct forum for Sequence job questions - General or Server - and explain why you think you'd want to be able to do this. People may then be able to...