Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple column update / Sybase

 
Brusk Baran
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic