DSXchange

Unique indexes get left in an UNUSABLE state after a load because they no longer contain unique values. That's the first thing I would look into, your initial truncated load is not working as well as you think.

It won't even start because starting off you have an index in an unusable state. Have your DBA fix that and then see what happens.

And how are you viewing the file? You'd need a hex dump to verify the contents otherwise all you'll see is what you are calling "junk values".

OK, nevermind on the codepage. You've got a hex value, what are you expecting in the sequential file? That same value or do you need to... 'decode' it?

You need to install an approved C++ compiler for your platform / version and configure DataStage properly for it. All in the Install and Upgrade Guide pdf, oddly enough.

Any chance the drive you are writing this hashed file to is full?

Just looks like it may be a codepage / character set issue. Can you post an example of this "binary" data?

I would think your "DT_TM" fields would need a proper TO_DATE() wrapped around them to make Oracle happy... or is that not the case with ORCHESTRATE fields?

The value you assign the environment variable in the Administrator should be $ENV and the default value of that environment variable when you add it to your job should be changed to $PROJDEF. In the job.

How much command line UNIX experience do you have? You need to navigate to the 'Project' directory in question and do an 'ls -ld' on RT_SCTEMP there: cd $DSHOME/../Projects/<YourProjectName> ls -ld RT_SCTEMP That should work unless your projects are in a non-standard location, in which case you'll n...

The Designer's Guide pdf manual has a discussion of Sequence jobs including the use of the Start/End Loop and User Variables Activity stages. Read it. This discussion should help as well, there are others here.

Sounds like it might be a bug in the connector if it is not releasing the tables. Check with your official support provider.

For the FTP stage, make sure you've got all of the permissions you'd need. Just because you can ftp somewhere doesn't automatically mean you can telnet there as well.

I wouldn't be quibbling if you were overriding their value. As noted, there's no reason to set any variable to its default value, especially an environment variable that will automatically get its value from the environment without any help from you. That's what they do.

Right, there's a Reset button in the Director client for that, looks like 'rewind' or two left-facing arrows.