DSXchange

Please make the post Green

Did only Update works ?

AND

Only insert works ?

Are you using DB2UDB Enterprise Stage ?

If yes then
set Write method = Upsert then
set Upsert Mode=User-defined Update & Insert or other option as per your requirement.

Thanks

ahmedwaseem2000 wrote:I cant see the code......

because you are not premium member,
can you tell us more about condition,and sequence path.

just make two job, 1) extract oracle database and load you date-value(which you want to pass to Red bricks query) to Hash file , 2)define a parameter , write query for red bricks in ODBC,pass that parameter in query. Then create sequence job, 1st job--->routine activity(DSUtilityHashLookUp)----2nd j...

why you want to pass value to environmental variables,
you can use DSRunJob in transformer to do this thing,

so you have any constrains to do this insert/update action.I mean any particular order issue like first update and then insert etc.?

what you want to do?
just pass the output from oracle table as parameter to second job(for red bricks),
or you want to define that value to any environment variable?
just clear this point.

Hi Friends, I've created several XML documents using XML stages in DataStage. When I viewed the files in the vi editor the XML tags are on separate lines as follows: <BEGIN_DATE> 09/25/2006 12:00:00 AM </BEGIN_DATE> <END_DATE> 09/24/2006 12:00:00 AM </END_DATE> but it should be like Good morning, fo...

Hi, I am having foollowing problem while generating output as XML file. Please anybody can help me out on this. It is from Teradata->Xfmer-> Hash->Xfermer-> XML OUT I have following 12 columns in my hash file BAN DUNS BANBillCycle Contactfirstname stprvCd cityNm addressnm cntctfirstname cntcsbusnm T...

so what i suppose to do to utilize 100% CPUs.

Thanks Ken,
I analyze my job, there is 4 CPUS,
it never reach to 100% if you make total of 4.
It reaches only upto 50% (if u make total)

[quote="kcbland"] Can you PLEASE state your version of Unix? Run prstat, topas, top, or glance and watch your job run. If the CPU for the job is at 100%, your job IS NOT SLOW.
I have OS: Sun Solaris .

Hi all, We have a job in that data stream apply to transformer and in Xmer 19 hashed file given for look up.among that 18 hashed file having same kind of meta data ,5 column ,all of it hash key.we comparing 3 of it and taking other 2 us look up output. I think due to this logic my job is running slo...

Hi all,
In my this job,after reading the database we have Xmer and in it 3 hashed file
given as look up , i checked from this 3 hashed file,2 of it having data in overflow file more then 2048.so it cause problem for reading or what?
reply me thanks.