DSXchange

Thanks ray for the help.
I created a custom trigger and now everything it's fine...

Thanks again....

I'm calling a routine from a "Routine Activity" stage. In the properties of the "Routine Activity" stage i set Trigger as "Return Vaue Conditional". My routine will return value either '0' or '1'. If the value is '0' then i'm calling the "UtilityAbortToLog" ro...

Thanks Ernie for the help..

Now i got the ouput..

One of the sequence job got locked, i'm able to view it in the lock window of "clean up resource" but not in the processes window.
I cleared the "Status file" but still i'm not able to release the lock.


Could anyone help me out...

I have a job that creates a xml file.It's working fine.
My requirement is if the input file is a zero byte then also xml template should be created without any data.


Please provide pointers to this....

I created a hashed file now i want it to access the hashed file using UniVerse stage.
I've used database name as "localuv" and the table name i've given as the Hashed file name.

But the error it throwing as "Table or View doen't exist"

Please provide some pointers to this...

Hi,
Instead of using the table as reference Why can't you just add an extra column and hardcode the column value of the reference table in the actual stream, since all the rows of the actual stream need this column.


Pls correct me if i'm wrong...

Yes i'm able to compile the jobs.
It's just showing the status as "running".


Thanks for the help..

The job is under "running" status for the past 2 hrs.
The "clear status file" is not active for this job and i'm not able to view the job in "Cleanup Resources" option.

What might be the reason?

I have a job that's running continuosly even if i try to stop it through director it's not stopping.
Can anyone tell me how to get the process id of the particular job and how to kill the job in Unix?

Please help me out..

Thanks priyadarshikunal for the help.
I change the order of the IF statements.

Now it's coming properly..

It's not working for BUSINESS_FG = 'U' also

I checked Shane, when i kept the same value as BUSINESS_FG = "G" and change only the PLAN_CD1 value for e.g. PLAN_CD1 ="CA" (Other than "CAT" and "CES") then i'm getting the correct output as "DM". If the problem is with the BUSINESS_FG = "G&quo...

Chulett
RIDER_FORM_CD is BLANK..
I've checked the code and it's flow it's correct.

I don't know what the problem..

Can anybody provide an alternate solution to this..

The following code is of a routine : ***************Routine Start*************** Ans = "" VAL = "" IF PREMIUM_CATEGORY = "4" THEN VAL = "SY" END IF PREMIUM_CATEGORY = "3" THEN VAL = "MA" END IF PREMIUM_CATEGORY = "2" THEN VAL = &q...