, SQL, SQL, . SELECT, INTO. Peel .
EXEC SQL SELECT snum, sname, city, comm
INTO:id_num,:salesperson,:loc,:comm
FROM Salespeople
WHERE snum = 1001;
INTO. , , INTO, , , .
INTO, . INTO . . , . . , SELECT INTO :
, , , , , . , , , , , 17 18.
GROUP BY.
SELECT DISTINCT , ( ), :
EXEC SQL SELECT DISTINCT snum
INTO:salesnum
FROM Customers
WHERE snum = (SELECT snum
FROM Salespeople
WHERE sname = 'Motika');
, Salespeople.snameSalespeople.snum , , Customers.snum , Salespeople.snum, , .
, , , , , , , . ! , , , , , . , , , SELECT INTO .
, , , .
SQL , -, , . , . , . , . , , ? , , .
|
|
, , . SQL , , , .
, . , . , , . DECLARE CURSOR, :
EXEC SQL DECLARE CURSOR Londonsales FOR
SELECT *
FROM Salespeople
WHERE city = 'London';
; . , , , , . , , : , ...... . , ORDER BY - , .
, , :
EXEC SQL OPEN CURSOR Londonsales;
, , DECLARE FETCH. , FETCH, , .
EXEC SQL FETCH Londonsales INTO:id_num,:salesperson,:loc,:comm;
, . FETCH . , FETCH , , , , , , , .
, , , , ,
Look_at_more:=True;
EXEC SQL OPEN CURSOR Londonsales;
while Look_at_more do
begin
EXEC SQL FETCH Londonsales
INTO:id_num,:Salesperson,:loc,:comm;
writeln (id_num, Salesperson, loc, comm);
writeln ('Do you want to see more data? (Y/N)');
readln (response);
it response = 'N' then Look_at_more:=False
end;
EXEC SQL CLOSE CURSOR Londonsales;
, := " ", = " ". writeln , .
, Look_at_more "", , . , . , . N (), , .
|
|
Look_at_more response boolean char , SQL, SQL.
, -SQL . , CLOSE CURSOR OPEN CURSOR. , , , OPEN CURSOR, .
, , .
, SQL , . , , .
, . FETCH , , INTO. , , , , , N.
SQLCODE
, , , . , , , SQL . SQLCODE ( SQLCOD ) . , SQL, B. SQLCODE , SQL. :
1. , . -:
) SELECT .
) FETCH , .
) INSERT (, , , ).
) UPDATE DELETE , , , .
, SQLCODE = 100.
2. , . , SQLCODE = 0.
3. . , , (. 23).
SQLCODE = , . , . , , , , , , , . , , .