my dog learned polymorphism*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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.
 
Don't get me started about those stupid light bulbs.
 
subject: multiple column update / Sybase
 
Similar Threads
return after jsp:forward action
question regarding looping
which ofenclosing page variables can be automatically used by the dyna.included file?
APACHE soap api vs SUN API
WebsphereAS 4.0 RequestDispatcher.forward() problem