change code

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

change code

Post by samsuf2002 »

Hi,
can any send me the change codes for update ,insert, same copy and del
i am using sql server

thanx
hi sam here
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

These are configurable using optionally added properties. The default values may be found in the Parallel Job Developer's Guide manual. Are you using a Difference or a Compare stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
iamnagus
Participant
Posts: 48
Joined: Wed Sep 29, 2004 1:16 am

Post by iamnagus »

The default values(In Change Capture Stage) for Update:3
Insert:1
Delete: 2
Copy : 0
But you can Alter/Override these values if want.

You can find these settings in Chage Capture under the tab properties/Options.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

These codes or independent on Database you use, but the stage you use.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply