Anonymous user
Parameterized SQL statement: Difference between revisions
→{{header|SQL PL}}
Line 1,047:
SCORE INT,
ACTIVE SMALLINT,
) @
Line 1,059:
UPDATE PLAYERS
SET NAME = PLAYER_NAME, SCORE = PLAYER_SCORE, ACTIVE = PLAYER_ACTIVE
WHERE
END @
INSERT INTO PLAYERS VALUES ('Pele', '1280', 0, 10)
CALL UPDATE_PLAYER ('Maradona', '600', 1, 10)
SELECT * FROM PLAYERS @
</lang>
Output:
<pre>
db2 -td@
db2 => CREATE TABLE PLAYERS (
NAME VARCHAR(32),
SCORE INT,
ACTIVE SMALLINT,
JERSEYNUM INT
) @
DB20000I The SQL command completed successfully.
db2 => 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 JERSEYNUM = JERSEY_NUMBER;
END @
DB20000I The SQL command completed successfully.
db2 => INSERT INTO PLAYERS VALUES ('Pele', '1280', 0, 10) @
DB20000I The SQL command completed successfully.
db2 => CALL UPDATE_PLAYER ('Maradona', '600', 1, 10) @
Return Status = 0
db2 => SELECT * FROM PLAYERS @
NAME SCORE ACTIVE JERSEYNUM
-------------------------------- ----------- ------ -----------
Maradona 600 1 10
1 record(s) selected.
</pre>
| |||