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


Win a copy of Java 8 in Action this week in the Java 8 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple column update / Sybase
 
Similar Threads
WebsphereAS 4.0 RequestDispatcher.forward() problem
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