DSXchange

You can also use Sort stage and then Remove Duplicate stage. Leave the partitioning as Auto.

Interesting.

Is this script file provided by Datastage?
What folder do you run it from?

Tony, I don't see an issue here. When you use "entire", it copies 8 times and you get the warning. When you use "hash", you don't get it because each node gets only one unique key. This is how it is supposed to work.

Craig, I need to update some data in the inserted rows after all rows have been inserted into the table. That's why I need to use "After SQL statement".

Let me know what other detail you need.

Thanks Teej and Craig for your responses. Craig, building a stored procedure in Oracle and calling it from Datastage is not an option. I have to do this from within the job. Teej, it has to be done after all inserts are done in Oracle connector stage. That's why I chose the "After SQL statement...

I tried to raise an error by doing a SELECT into a variable from an empty table. The code hits the exception block and raises an error like it should in Oracle but when I put it in Datastage "After SQL statement", it executes fine. There are no messages in the Director. I also did the DBMS...

Is there a way to see the output of:

dbms_output.put_line

in an "After SQL statement"?

It doesn't show up in the Director.

I guess my question is, if the rows come in that order, would
12 X
be the first row inserted and made current? Would
12 A
be the second row inserted and made current and
12 X
row expired?

If I send 5 rows to a SCD stage with the same key for Type 2 determination, does it insert/update rows based on a certain criteria or does it do it at random? For example, if I have data like this: Business Type 2 Col Key 12 X 12 A 12 Y 12 C 12 S It sets the first 4 rows as not current and the final...

I did. They all have:

drwxr-xr-x

Also, when I execute:

sqlplus Userid/Pwd@SrcName < /fullpath/MySqScript.sql

from within /fullpath/, it works fine.

I have an execute command stage in a sequence job. I am running the following command in the execute command stage: sqlplus Userid/Pwd@SrcName < /fullpath/MySqScript.sql When I try to execute the sequence job, I get the following error: seqJob..JobControl (@ExecCmd1): Executed: sqlplus Userid/Pwd@Sr...

I am assuming that in the "Input Value" of the "Before-job subroutine", you put in something like this:

sqlplus userid/pwd@server MySql.sql;

Can you tell me how you returned a 1 from the sqlplus call?

How do I enable NLS? I looked at this post:
viewtopic.php?t=104828&highlight=enabling+nls
and few others. I don't have a NLSMODE setting in my uvconfig. Do I need to uninstall and reinstall Datastage to enable NLS? Or can I check something else?

rkashyap, I did that step. Still Unicode is not visible.

Ray, in the Administrator, NLS is disabled for the project. The button is grayed out.

I was able to display the Extended column. I tried selecting both Char and Varchar but Unicode does not show in the Extended column. The drop down is empty.