DSXchange

Hi, I datastage job Comb which runs fine without any error.-- OCI - Transformer - OCI When I execute the same job through sequencer, it gives ORA - 12154 Error. What I doing in sequencer is 1. Wait for file to appear. 2. Run the job Comb. When I check the error log for Sequencer , it reads as File a...

Hi,

Yes and the answer is " There is NO way not to commit."

Ketfos

Hi, I am using a simple sql in input OCI stage (Select name, address from customer where customer name like 'K%' ) In the Output OCI stage, I Update the customer table with Udpdate Action - Delete existing row only SQL shown is - Delete from Customer where customer name:=1 Also I write the deleted r...

Hi
I am deleteing records in Oracle table and writing to a sequential file.

Using Datastage - OCI - Transformer - Seq File

As I understand Datastage does implict commit on INSERT, DELETE, UPDATE.

Is there a way to prevent implict commit?

Ketfos

Hi,
What is CRC example? Pl dive clear details of your problem

Ketfos

Hi,
Can modify your transformer from update/insert to

1. update only

2. insert only

and execute your job.

What errors do you get know.

Ketfos

Hi,
Did you upgrade your DB2 recently?
Did you face any catalog problems? Is the catalog working fine?
O ryou simply upgrade your catalog and try job again.

ketfos

Hi Craig, You are correct. The job runs fine if you are logged as dsadm. Yes unlike 5.x, the .sh file gets deleted after the execution of the job. I went to the Unix box and logged in as regular user (not dsadm). I created a empty file with name "sendmail_sequence1.sh I logged into datastage as...

Hi,
I logged in dsadm and executed the job again in 7.5.
But I got the same error message "permission denied"


Ketfos

Hi,
Yes, I executed the same job in Datastage 5.2 and it worked fine.


Ketfos

Hi,
DataStage 7.5
OS UNIX HP

Ketfos

Hi, I am using a Notification Activity where i give the Mail paramters like SMTP Mail Server Name, Sender address, Reciepient Address, Email Body. When I execute the job named testseq which is - "Wait for File Activity and Send a Email Notification " It gives error message "Error Exec...

Hi,
What is the data type of the target field and input field?
Are you using any routine/function in transformer for converting input date value?


Ketfos

Hi,
You can use Ereplace function to get rid of it.

Ketfos

Hi,
Overall a Static Hashed File can perform up to 80% faster that an equivalently configured Dynamic Hashed File.



Ketfos