DSXchange

That's the way it works. You are responsible for ensuring that no duplicates are sent to the load process so that the Primary Key constraint is not violated.

Yes. Blank in the Sequence Job Activity parameter = take the default setup in the job. Keep in mind the fact that that's not always allowed - required parameters with no default will force a parameter value in the Sequence.

EReplace or Convert will do it, but the Trim should work as well. Your problem is you used double-quotes to enclose a double-quote. Put single quotes around it.

"Menu bar" meaning the one with "File View Tools Help"? I think there are postings here with the registry key you'd need to edit to get this back.

It's time to start a new post where people can help you configure your installation and C++ compiler.

There is a known crash bug in the Designer when working with Sequence job, ask for the patch from your official support provider. Or you could try playing the 'completely uninstall and then reinstall the client' game. Completely in this case means removal of all Ascential keywords from the registry ...

Suggest continued patience, that or ask your offiicial support provider. I for one don't have access to 8.x to answer a question of this nature.

Then they they throw you into the deep end of the pool to put out the fire.

It does sound like a permissions problem. What owner/permissions do you see on the files in $DSHOME? Mine are typically either 755 or 644 and owned by dsadm/dstage.

Hmmm... never seen that one before. Is that the location where you told the installer to "unpack" the cdrom?

It may be time to call in your official support troops.

Hmmm... we really frown on hijacking other people's threads around here. You really should start your own conversation, even if it is related to an existing topic. And especially when it isn't.

DS 8.0.1 doesn't support Oracle 8i. Not for the repository but I would think you could still connect to one as a data source or target - you'd just need to leverage an 8i client. And you can add Environment Variables to a Project so that you can override the $ORACLE_HOME and $SHLIB_PATH (or equival...

rishi wrote:

chulett wrote:specify the 9i client in the dsenv for DataStage. It will work just fine for both 9i and 10g. ...

and put 10g database tns enteries in 9i's tnsnames.ora file???

Sure. A tns entry is a tns entry and it isn't really client specific even though that's where it lives by default.

You take a 'least common denominator' approach and specify the 9i client in the dsenv for DataStage. It will work just fine for both 9i and 10g.

Different thread.

Posting from another airport lounge?