Hi Guys,
I want to update into ORACLE table :
4 columns(feilds are empty) - NotNull And Not part of PrimaryKeys
Col1
Col2
Col3
Col4
Out of 25 columns(data is existing).
And Data Also doen't have NULL Values
Ihave Searched this Forum and Itried But I couldnot Do Update,
Some one, Any Solution.
Thanks In Advance
Martin.H
Update
Moderators: chulett, rschirm, roy
Martin, you're going to need to restate your problem. We can't really tell what your issue is or why you "could not do update" from your post.
Are you using one of the OCI stages? Did you notice you could change the "Update Action", and that there are several that do various forms of updates? When you have your columns and table name populated, switch to the SQL tab and you'll see the SQL the stage will run against your table. Switch the update action and the SQL will change. Just looking at what it will do is a good way to learn the differences between the various actions.
If all you want to do is update four columns in a table and leave the other 21 alone, all you need to include in your job are those four fields (plus whatever key fields are needed to identify a record) and use the "Update existing rows only" update action. If the fields are required, meaning they will not allow null values, you'll need to ensure that you don't deliver any to the table by using appropriate constraints and derivations in the job. As Siva mentioned, some people will put a space in a not-null character field to signify it is "empty", or a zero in a numeric field.
When you come back with more questions, please make them as specific and clear as possible. Otherwise you may get answers to questions that you didn't even ask.![Wink :wink:](./images/smilies/icon_wink.gif)
![Confused :?](./images/smilies/icon_confused.gif)
Are you using one of the OCI stages? Did you notice you could change the "Update Action", and that there are several that do various forms of updates? When you have your columns and table name populated, switch to the SQL tab and you'll see the SQL the stage will run against your table. Switch the update action and the SQL will change. Just looking at what it will do is a good way to learn the differences between the various actions.
If all you want to do is update four columns in a table and leave the other 21 alone, all you need to include in your job are those four fields (plus whatever key fields are needed to identify a record) and use the "Update existing rows only" update action. If the fields are required, meaning they will not allow null values, you'll need to ensure that you don't deliver any to the table by using appropriate constraints and derivations in the job. As Siva mentioned, some people will put a space in a not-null character field to signify it is "empty", or a zero in a numeric field.
When you come back with more questions, please make them as specific and clear as possible. Otherwise you may get answers to questions that you didn't even ask.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: