Update

martin · Post by **martin** » Thu Aug 12, 2004 6:23 pm

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

rasi · Post by **rasi** » Thu Aug 12, 2004 6:29 pm

Explain a bit more to help you. Do remember spaces are considered to be values and not null. Check the length of those columns in the table.

Thanks
Siva

chulett · Post by **chulett** » Thu Aug 12, 2004 8:27 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 12, 2004 10:07 pm

If you try to update and the row does not exist, the update will fail. In this case you need to do an insert.

chulett · Post by **chulett** » Thu Aug 12, 2004 10:51 pm

It won't "fail" in the sense that you'll get an error message, it will just fail to update any rows.

Perhaps some other databases are different, but Oracle (and what I recall of Informix) is perfectly happy updating zero records.

martin · Post by **martin** » Mon Aug 23, 2004 10:35 am

sorry to reply Back,

Key Columns were not defined........i didnt see it .....i was confident that part was okay.........later i figured out........now its ok.

Thanks guys