DSXchange

Hi all, I have a below requirement , can you please suggest me how best to achieve this 1.I have one oracle table which will contain some columns (daily refresh) 2.I need to read the values from the the above table and pass them to an SP. 3 Need to execute the sp with those values as params. 4.Get t...

Thanks guys,

thanks Arun for your example

Got it guys,

I have copied the code content and created a new user defined routine , now I can do compile and its working perfectly.
I used Multi-Job compiler in vain

Thanks for your suggestions.

Thanks

ray.wurlod wrote:Can you make sure that the routine is compiled?

Ray,

Actually DSSendMailAttachmentTester is a by-default routine "save" and "compile" buttons are disabled , the only thing i can do is "test"

Thanks,

Hi all, I am trying to use the email attachment notification routine which is available in Routines\Built-in\Utilities\ DSSendMailAttachmentTester When i try to test that routine i am getting the below error Program "TSTDSSendMailAttachmentTester.B": Line 3, Unable to open the operating sy...

Thanks guys.. :D

Ray,

Actually I need a 12 hour clock with AM/PM

Thanks,

Hi all, I need timestamp in below format MM/DD/YYYY HH:MM:SS AM/PM Currently I am using below function OCONV(DATE(),"D/MDY[2,2,4]") :" " : UPCASE(OCONV(TIME(),"MTHS")) Is there any better way to do it as the function I'm using is appending seconds with AM/PM Eg:-01/01/2...

chulett wrote:Don't confuse the two - transaction size and array size are two different things

Got it Chulett

And guys finally setting transaction size to 1 solved my issue.

Thanks,

Sorry guys i am off for few days. i am not sure whether i set the transactions array size to 1 or not.
Will check that on this Monday and update you

Thanks

Chulett,

Tried that option also by making sure Reject is the last link , but of no use.

Thanks

Hi Guys,

But my input doesn't contain any null values and my rejected data is due to 'Unique key violation' constraint defined on the Oracle table.

Thanks,

I don't 'see' any harm in your approach.

Thanks,

Hi, I am trying to insert data in a Oracle db using Oracle OCI stage. I need to capture the records which failed to insert in the table. So I have created a new link and marked the link as rejected and in transformer i have put a constraint like oracletable_linkname.REJECTED on the rejected link. bu...

Hi Sreeni,

But i need to distinguish the columns , how can i do that

Thanks