Anonymous user
Parameterized SQL statement: Difference between revisions
→{{header|Tcl}}
Line 1,038:
-------------------- ---------- ----- ----------
Smith, Steve 42 TRUE 99
</pre>
=={{header|SQL PL}}==
{{works with|Db2 LUW}}
<lang sql>
CREATE TABLE PLAYERS (
NAME VARCHAR(32),
SCORE INT,
ACTIVE SMALLINT,
JERSERNUM INT
) @
CREATE PROCEDURE UPDATE_PLAYER (
IN PLAYER_NAME VARCHAR(32),
IN PLAYER_SCORE INT,
IN PLAYER_ACTIVE SMALLINT,
IN JERSEY_NUMBER INT
)
BEGIN
UPDATE PLAYERS
SET NAME = PLAYER_NAME, SCORE = PLAYER_SCORE, ACTIVE = PLAYER_ACTIVE
WHERE JERSERYNUM = JERSEY_NUMBER;
END @
INSERT INTO PLAYERS VALUES ('Pele', '1280', 0, 10);
CALL UPDATE_PLAYER ('Maradona', '600', 1, 10);
</lang>
Output:
<pre>
</pre>
| |||