DSXchange

Make 'dstage' their primary group.

i) Stored procedure executed but never finished. I could see a lot of rows being processed in the output link. But the row count in database was correct and the same. The rows being processed through the link never seemed to stop so I had to stop it. That's why I said you needed "a constraint so it...

And just in case it's not obvious, it would look like this when there are actual values: <coordinate precision="specific" suppress-geocode="false" suppress-map="false"> <latitude>28.9028</latitude> <longitude>-81.8644</longitude> </coordinate>

Sorry, I didn't reply back because I've never seen such a thing and honestly have no idea what may be causing it. How about you open a case with your official support provider and let us know what they say?

This starts to get a little over my XML head, so wondering if someone here can help. We've been asked to set a nillable field to true when we are purposefully leaving it empty and I'm wondering if there is a way to automate this or if a manual solution is in our future? Here is a snippet of the xsd:...

Me personally, I don't see how any table structure can change 'randomly'. That concept is a little... scary.

Fair enough, can't comment on that aspect of this as all I've ever done is a 'root' install. Find it a little hard to believe that you must always start over fresh with a non-root install, but whatever.

Now you are stuck with trying to rebuild the VC projects.

Administrator / Project / Properties / Environment / User Defined and then simply add it. It will be in play for all jobs in the project.

Which DataStage versions honor this environment variable?

Naturellement.

Don't let Larry hear you say that!

Found this, perhaps it will help you as well: I researched this and found that there is an issue with the OCI stage specifically on Itanium platform connecting to 10G. Please do the following: 1) cd `cat /.dshome` 2) . ./dsenv 3) cd lib 4) ln -s $ORACLE_HOME/lib/libclntsh.so.10.1 libclntsh.so.9.0 Pl...

You can add a transformer that links to the SP stage. Add a stage variable so it will compile and a constraint so it only passes out 1 row, that will trigger the stored procedure and satisfy the job's need to have an active stage.

Well, now hold on there partner. Edwin just said 'thanks' without letting us know which little pearl of wisdom he was thanking us for. The jury is still out.

That doesn't really help. And you can edit your own posts, no need to post again just to add that bit.

Try posting an actual question, one that makes sense. What sort of doubt or problem are you having? I for one an not even going to try and answer anything that wide open and vague.