As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options
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