wood burning stoves 2.0*
The moose likes JDBC and the fly likes multiple column update / Sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "multiple column update / Sybase" Watch "multiple column update / Sybase" New topic
Author

multiple column update / Sybase

Brusk Baran
Ranch Hand

Joined: Nov 15, 2001
Posts: 132
Salut comrades,
I have to make a complicated updated to a temporary table, which will be nourished with data from around 5 tables.(db= Sybase 12.5)

whatever i've tried, get always errors warning about Incorrect syntax near '('. seems that I MUST update the columns one by one.. is it so?
regards,
[ November 26, 2003: Message edited by: Brusk Baran ]
[ November 26, 2003: Message edited by: Brusk Baran ]
Brusk Baran
Ranch Hand

Joined: Nov 15, 2001
Posts: 132
It seems that a simultaneous multiple column update to a table is not possible. Instead one by one....
create index ...... with ignore_dup_key is also very helpful.. to insert new rows without thinking of duplications, they are ignored implicitly.
This was helpful in my problem.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple column update / Sybase