DSXchange

Hi,
What is your expected output?

Ketfos

Hi, What is understood is Even after you kill the job and related processes, it shows the status as 'RUNNING' That was the reason i specificallya sked you to look the status of job. Before doing anything further, you need to kill all processes related to this on your client machine using the Clean U...

Hi, Could you kill the job and related server processes succesfully? After this, did you check the status of job in Director? Was it still showing the job status as running? If it was showing job status as running after killing the processes, then you need to look for processes related with this job...

Hi,
What are you doing in TFM and hash file stage?

Ketfos

Hi,

We have been using OCI8 with 9i client talking to 9i and it works fine.


Ketfos

Hi,
Is there any error text with error message?

Could be you not have access permissions/rights to execute the stored procedure.


Ketfos

Hi,
You have mentioned that job remains in running state, something like infinite loop.

1. Kill the job and related process on the server and client.
2. Open the job in Designer.

Can you open the job in Designer?

Ketfos

Hi,
Pass these values as parameters in Notification Activity Stage in DS 7.5
and it works

Ketfos

Hi Phillips,
Just use the Erepalce function as I mentioned to the output you get.
It will remove the "-" character from your data.

Also DIGITS Transform is availabe in 5.0


Ketfos

Hi,
You I agree with you.

I could not find the DIGITS function in Datastage 5.0. Is it correct?

I found Ereplace and Convert functions can help.

Ketfos

Hi,
Try using Ereplace function as shown

Ereplace((Oconv(LinkName.DateColumnName, "DYMD[4,2,2]")),"-","")


Ketfos

Hi,
Thanks, I was able to kill by cleaning resources and looking for pid# with locks.

Ketfos

Hi,
When I go to Unix and issue the command
kill 9261

I get a message " Specifed Process doesnot exist"

ketfos

Hi, I am unable to open a datastage job. When I try to open it, it gives a message "Job Accessed by another user" When I go to Director and view the status , it shows "Running". When I try to stop the job, I get a message "Stop Request has been sent to Server". It keeps...

Hi, Can you check on following? What is the value of NLS_LANG parameter defined in your profile? The client CHARACTER SET is defined by the NLS_LANG parameter, and the client NATIONAL CHARACTER SET is defined by the NLS_NCHAR parameter. The client has to have NLS_LANG set to enable the rest of the N...