DSXchange

Hi,

What is the Special Character there.

Thanks & Regards,
Sudhakar

Hi,

I think you did some changes at database and not fired the Commit Statement. Check this scenario...

Regards,
-- sudhakar

Hi Saraswati, You need to pass the no.of records of a file into the job as a parameter. So, in sequence use the Execute Command activity to count the no.of records in a file. And in the job activity of other job specify Execute Command activity. command_output to count parameter of that job. Regards...

Hi,

I did not understand properly. Can you explain some more elaboratedly.

Regards,
-- sudhakar

Hi,

By using stage variables u can get this result.

Regards,
-- sudhakar

Hi,

Use numeric function to round the value.
Else convert into char and send it

Regards,
-- sudhakar

Hi SHIVARANJANI, Here i have one more way to resolve this problem. That is Put the following condition for LAST_UPDATE_DATE column derivation in Transformer stage. If IsNull(<<link_name>>.LAST_UPDATE_DATE) Then SetNull() Else <<link_name>>.LAST_UPDATE_DATE Regards, -- sudhakar

Hi Sanjay,

Thanks for your reply. Now, it is working by your idea.
I just want to know why it is giving for that number only(for those many digits), for other numbers it is working properly.


Thanks,
-- sudhakar

Hi, I am reading string value -300000000000.0000 from oracle9i and loading to oracle9i database. The target column datatype is number(38,10). While loading this data i am getting following fatal error. Failure during execution of operator logic. APT_CombinedOperatorController,0: Internal Error: (byt...

Hi anwarsait,

The one of the job in batch is not in runnable state. Try to specify invocation ID and run it. Because one job is used by many other sequences at that time this error will occur.

Regards,
-- sudhakar

Hi Ray,

In logs it is showing as it is occuring in transformer.

Thanks,
-- sudhakar

Hi,

I am getting the follwoing error in Parallel edition.

unable to run job --2

The above fatal error is occuring in Transformer (both Transformer and basic Transformer).


Thanks,
-- sudhakar

Hi,
I have to send a email notification to the parameter file (in parameter file we listed some of the reciptents names)

Hi, I forgot to specify % in date format. If IsNull(job.empl_status) Then SetNull() Else If job.empl_status="D" Then If IsNull(pers.dt_of_death) Then DateToString(job.effdt,"%mm%dd%yyyy") Else DateToString(pers.dt_of_death,"%mm%dd%yyyy") Else SetNull() Regards, -- sudha...

Hi, If IsNull(job.empl_status) Then SetNull() Else If job.empl_status="D" Then If IsNull(pers.dt_of_death) Then DateToString(job.effdt,"MMDDYYYY") Else DateToString(pers.dt_of_death,"MMDDYYYY") Else SetNull() If job and pers are not link names then you need to add the l...