DSXchange

While obviously you could poll an Oracle table every X for this record, or do the same for a file, why not simplify things? Why not arrange for whatever process knows when this 'load is completed from source' to then start your Sequence? Should be trivial with an Enterprise Scheduler and a 'dsjob' ...

First step is you telling us how you propose to detect - from UNIX - the change of state of the table in the holding area. Once you have advised that, then maybe we can proceed with further analysis. Thanks for your response. That is we have a table in the holding area to record the status of the r...

Hi All, I am looking out for some design suggestions for the following requirement mentioned below. We need to replicate data from the holding database after the replication from source to holding is completed by other systems. we need to trigger our sequence once the status is completed in one of t...

Hi All,
I have a requirement as mentioned below.

If Dept_no=100 Or Dept_no=101 Or Dept_no=102 Or Dept_no=103 Then 1203.24 Else If Dept_no=104 Then 12345.89 Else 0

Can any one of you please tell me how to use Case Structures in place of Nested If Conditions.

Thanks in Advance.

Use EREPLACE fucntion to achieve this.

47shailesh I have cleared status file using ur option and logged out the specified job but again it is displaying error "Can not exclusive access, job can be monitored"............ Ray, Where these files are available which you have mentioned........and how to unlock it " RT_LOGnnnn h...

Thanks ya

After killing the job only I am getting the error like this ya...

I have checked it...but i do not have that RT_LOG file ya

Hi All, I am able to open a job and I am able to change it but it is displaying the following error while compiling..... "Can not get exclusive access to executable file for job may be being monitored"... It is a multi instance job, and currently I have not opened any monitor in director.....

Hi All, I am not able to release my locked job from the director....Yesterday suddenly the connection is broken from the server. After that when I tried opening the job it is saying "ACCESSED BY ANOTHER USER".. Till today it is displaying the same error.. Please help me in this regard... R...