DSXchange

Hi, I want to put Null into database for a particular decimal column if I dont get any value from source. But when I try to use the SetNull function , I get the followin error:- value larger than specified precision allowed for this column Need help to understand why I get this error and also the wo...

Hello, I hv to load data frm a source view in foll way:- Compare the incoming record with existing ones in target, and if there is any difference, load the incoming record else dont load. There is no key column defined in the source, so we cant check any 1 column but need to check data in all the co...

Hello, I want to set null value for some decimal fields. These fields are defined as number in my db(oracle). When i use SetNull() func to do this,it gives some precision related error and job aborts. But SetNull() function is working fine for date fields. What can be done to use SetNull() for decim...

Hello, I am facing prob in calls to certain instances of one job sequencer. I have a call to one audit seq from within my parent seq. Parent Seq:- InitJob-> Job1, Job2, Job3, Job4 ........Job n Job1 -> AuditSeq.1 Job2 -> AuditSeq.2 ... Jobn ->AuditSeq.n The prob is that only certain instances of Aud...

Hi, I am creating my first parallel routine. I created the code in C and after compiling it I kept it in lib folder of PXEngine. I am now able to view and use the routine in transfrmr bt wen i compile the job it gives error at transformer stage :-- 'Parameter specified but not used in flow:DSPXWorki...

Hello, I want to know whether there is a way to call the same routine with different number of arguments. e.g CALL1:- rt1(arg1,arg2) CALL2:- rt1(arg1,arg2,arg3) I created a routine, and when i tested it , it doesnt give any error even if I provide the 3rd argument or not. But when I try to use it in...

Hello!
I m having two sequences A & B. They have to run in parallel. The prob is that i have one job in seq A that has to wait for a job in seq B to complete first. Is this possible? And if yes how? Would be grateful if you could provide any guidance.

I saw the casestudy. It is not wht i m trying. Actually it is nt just readin a row nd makin columns out of it. It is exactly like a matrix transpose. 1 2 3 4 5 6 7 8 9 becomes... 1 4 7 <------ 2 5 8 3 6 9. So in effect my 1st row O/P will consist if I/P frm 2 rows below it also ( see -> 4 7 in first...

I hv my src file as follows: cust prod UOM Jan Feb Mar c1 p1 u1 2 7 6 c1 p1 u2 1 5 7 c1 p1 u3 6 7 8 c1 p2 u1 2 3 5 c1 p2 u2 1 1 9 c1 p2 u3 6 7 8 i want target as :- cust prod mth u1 u2 u3 c1 p1 Jan 2 1 6 c1 p1 Feb 7 5 7 c1 p1 Mar 6 7 8 .......... and so on. i.e month cols become rows and units will ...