DSXchange

Try assigning the value returned by your Routine to a variable, i.e.

Hi Mike Ah, we're using v7.5. Can you manually specify the table definition of the reject link? In v7.5, the columns are read-only and automatically taken from the input link with the additional sqlcode . If you can, try to specify the table definition as v7.5 would. PS. "děkuji" means &qu...

Hi mmorelli

Make sure that:
Ora Ent Stage > Input > Properties > Write Method = Upsert

The column sqlcode:Integer will then be included as the last item under:
Output > Columns

Also, don't forget to set:
Input > Properties > Output Reject Records = True


děkuji.

Automatically included in the reject link of an Oracle Enterprise stage with properties mentioned in vmcburney's reply is the sqlcode (Integer).

E.g., -1400 (cannot insert NULL)

Have you specified a value for the property
Oracle Enterprise > Input > Properties > Connection > Remote Server?

The username to use to log on to windoze should be a valid/authorised MetaStage user. As Ray said, try the username you used during installation. On the other hand, the username to use in the MetaStage login box should be an authorised user or the owner of the MetaStage Hub (a.k.a. the database wher...

Better just create a symbolic link to it

   $ ln -s liborchoracle.so orchoracle.so

During the installation of DS EE, you probably did not specify the location of your Oracle installation. The installation script would have also asked you to confirm which version of Oracle you have. Anyhow, check out which libraries these symbolic links point to:    orchoracle8i.so    orchoracle9i....

Create a symbolic link to the appropriate library, i.e. for 10g on SunOS:

$ cd $DSHOME/../PXEngine/lib
$ ln -s liborchoracle10gsun4.so orchoracle.so

HTH

In fact you can pass where clause conditions as job parameters (including column names, operators and constants) e.g., STATUS = 'A', STATUS IN ('A', 'B', 'C').

Just define a job parameter, say CONDITION, and put #CONDITION# in your ODBC stage's Outputs > Selection > WHERE clause.

How about using:

  Director > Job > Cleanup Resources
    :: Release All, and
    :: Logout

and then Clear Status File and/or recompile the job...

Then how do you add a sequencer job in Job Control (Under Properties) in Add Job list box.?

They're already there. It's just that the list box items are grouped and sequences appear after the jobs.

Ravi, you might want to set this EV, too

  $APT_ORAUPSERT_COMMIT_TIME_INTERVAL

Julie, try this user-defined SQL:
If your NULLABLEKEY is made up of CHARs, use a specific string instead of -99999.

"By default a controlled job inherits any row or warning limits from the controlling job. These can, however, be overridden using the DSSetJobLimit function." In a BASIC job control maybe, but in a sequence it seems (to me at least) that there is no obvious way of changing the inherited li...