hi folks,
while running the job type 2 implemetaion insert or update ca,t be done. Always job running mode. it will not whether successes or failure . Any one help me on this is really appricaiable
Thanks,
Ravi
type 2 implementaion in update problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Wed Feb 08, 2006 12:54 am
Ravi,
you will need to explain a bit more about what your problem really is in order for anyone to be able to help you. I assume by "type 2" you mean you are doing a slowly changing dimension in your job. What database? What part of the job is hanging? Is it on the first row?
you will need to explain a bit more about what your problem really is in order for anyone to be able to help you. I assume by "type 2" you mean you are doing a slowly changing dimension in your job. What database? What part of the job is hanging? Is it on the first row?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
And you are correct that you can't use the 'Insert or update' action. You need to separate the two actions into different links as you'll need to insert all rows and possibly update old ones.
Last edited by chulett on Mon Apr 24, 2006 6:26 am, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 5
- Joined: Wed Feb 08, 2006 12:54 am
database db2
my databse db2 .In datastage iam trying to type2 which existing record then update ,new record will be insert when i am trying to start this operation my job hangup it can,t be perform successes or failure .
Can any one help me
Can any one help me
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Have your DB2 DBA show you that you are introducing self-locking processes. Then design your job in a way that this does not occur. Take note of the advice given by Arnd and Craig.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.