DSXchange

Your support provider? Folks post here if they can contribute. By an unspoken understanding, folks don't post if they have nothing to contribute. You've had some advice from here; obviously you are unsatisfied with it. Why not make your support provider earn some of that maintenance revenue they col...

----> Transformer1 -----> Transformer2 -----> Oracle | | LinkA | | LinkB V V Rejects1 Rejects2 Transformer1 looks after any business rules, sending its rejects out a rejects link. Transformer2 looks after any rows rejected by Oracle, by having LinkA with no constraint expression and LinkB handling ...

From UNIX, assuming you have DSHOME environment variable set: find / -name X -print -exec $DSHOME/bin/UVfile {} \; 2> /dev/null For those not familiar with UNIX: find / searches the tree beginning at / (the root file system) -name introduces the name for which find is looking -print causes...

If you solve the state file problem (see other thread), the problem with the job sequence will also disappear, as it's a direct consequence.

I can't find anything related to this error but then, as the error message states, it's an internal error. You need to report this to your support provider, ideally with a reproducible example. Perhaps the stage is not successfully writing the state file after the first run - have you checked that y...

Given that the Teradata Enterprise stage fails, have you contemplated using the Teradata API stage?

Would it not be better to have a job sequence detect whether there were rows in the Data Set and make the decision to run the job only if there are?

Does the Data Set actually exist? Please verify (or otherwise) using the Data Set Management tool or the orchadmin or dsrecords command. What will be the benefit of running the job under this circumstance? Would it not be better to have a job sequence detect whether there were rows in the Data Set a...

Duplicate Post!

Please respond to this post instead.

Under the Import > Table Definitions menu you will find Orchestrate as one of the options. On the dialog that is opened you will find that the third option is to import a database table using the orchdbutil facility. You can learn more about orchdbutil in the Orchestrate Users Guide, for example if ...

Looks like the Surrogate Key Generator stage is having problems finding the range of key values that it must use to generate key values. Are you using a state file or a database table as your reference source for surrogate key values?

There is no Version Control for version 8.0.

Some time in the future (8.2 has been postulated) there will be an interface to a source code control system - probably ClearCase initially since IBM own that.

Go to the Format tab on the downstream sequential file stage. Tell us what the Pad Character field contains.

Can you post a couple of lines of data?

What version of Windows is your PC? If it is XP with service pack 2, you may need to apply a patch from DataStage (IBM).

Your Transformer stage has two outputs; one going to the Oracle table (let's call this LinkA) and one handling rejects (LinkB). LinkA has NO constraint expression. LinkB is marked as handling rejects. Define an integer column on LinkB derived as the output link variable LinkA.DBMSCODE. If you need o...