DSXchange

Hi, I am also getting the error as "An inidentified error has occurred for reject option" while compiling the job. I have selected reject option in the lkp failure fail drop down. Its happening only for the Lookup Failure Reject option. The same when i tried on another installation, it wok...

Hi, Thanks a lot Ray for your info. I am now able to run the job. I just want to put the details of the back tracking this issue as it can be helpful for some one else facing similar kind of problem. After checking that the logic is working fine, we thought of two options:- 1. Either the data we are...

Hi Ray,

i tried with that.
I used the $APT_DISABLE_COMBINATION and setting its value to true.

After using this i am getting the fatal error as APT_Decimal:Compare -Left hand side decimal has an invalid representation.

please tell me if you need any other information.

Hi Ray, The following are the stage variables. The stage variable in bold is the one which on replacing by Zero my job is running fine. Stage variable: StgStdPri (Decimal 12,5) Derivation: StgDosPri Stage variable: StgDosPri (Decimal 12,5) Derivation: IF ToTrans.eoynpt=0 THEN '0' AND StgStdPri =0 EL...

Hi, I am gettting the following errors while running my job. APT_CombinedOperatorController(2),1: Fatal Error: APT_Decimal::asIntegerS64: invalid representation in decimal; the leading nybble must be zero with odd precision . I am getting with one of the stage variables( i came to this conclusion be...

Thanks a lot Chulett.

Hi,

Is the version 7.5.2 is for Datastage EE edition only or it is there for Datastage Server Edition also?

The above error i got while i was converting that number to char by using TO_CHAR function [ This is only way i was able view the data at source level ] and then using DecimalFromString function in transformer and changing my target data type to Decimal[42,2]. But as per the info from prior post it ...

Thanks Kumar for your time and info. whats your end result when you change this? Dont just rely on Veiw data, look out in the target database . How is it possible to reach upto target if i am not being able to view the data at the source level? Will the job run when there is a import error at the so...

Sorry Ray,
Actually there was no need for me giving that reply,but your quote was so nice and sweetly timed that i couldn't able to stop myself by putting somthing from my side.

Will take care in future.

Thanks Chulett. 1.you make the metadata for that field Decimal(40) all the way through the job. 2.If you continue to get errors, please be specific what they are. Saying it 'aborted' or you 'got the same result' doesn't really tell us anything. Post them. Don't have access to DS right now i will che...

Ray wrote:The Two Secrets of Success

1. Don't tell everything you know.

thats really cool ray.
Excellent .
But then how this Forum is going to exit .

Thanks a lot Ray and Chulett for your time and info. So, when I suggested changing the metadata - I meant at both ends, not just the target. Is that what you tried and it still isn't working for you, san_deep? I tried out the following ways: [1.] I tried by changing the data type for that column at ...

Hi Chulett,

thanks for ur time and info.

But i am trying all this waht you have mentioned.
Its not working for me.

Is there any other way by which it can be achieved.

thanks in advance.

Thanks a lot Chulett.

I think its better to first analyze at the buisness level if we need that column or not,if still it is needed i will try to short out with my DBA here.

Thanks a lot for the info as i was not sure about handling the long data type in PX,now i will look for other way.