The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
Please vote in the Forum Structure Poll. Polling will close at 2PM EST on January 21, 2025.
DB2 SQL updates
Deebaser
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
I'm creating a report I previously created in sybase on a different DB2 system
In Sybase I have a lot of simple text updates like follows
UPDATE #deestable
SET Score_Rank = 1
WHERE score_txt = 'AWESOME'
So... I rewrite this simple update as best I can in DB2 syntax...
UPDATE SESSION.deestable tbl
SET (Rating_Rank) = 1
WHERE score_txt = 'AWESOME';
Predictably, I get an error about score_txt not being valid in the context where it is used.
Please help.
Fuck DB2
In Sybase I have a lot of simple text updates like follows
UPDATE #deestable
SET Score_Rank = 1
WHERE score_txt = 'AWESOME'
So... I rewrite this simple update as best I can in DB2 syntax...
UPDATE SESSION.deestable tbl
SET (Rating_Rank) = 1
WHERE score_txt = 'AWESOME';
Predictably, I get an error about score_txt not being valid in the context where it is used.
Please help.
Fuck DB2
Deebaser on
0
Posts
UPDATE SESSION.deestable SET Rating_Rank = 1 WHERE score_text = 'AWESOME';
Any reason you're using an alias there?
I tried your code, but Im still getting the same context error.
UPDATE SESSION.deestable SET Rating_Rank = 1 WHERE "score_txt" = 'AWESOME';
I'm a dumb.
"score_txt" on this database is actually "score_symbol_cd"
Thanks all the same