.


:




:

































 

 

 

 





, 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 = , . , . , , , , , , , . , , .





:


: 2016-07-29; !; : 438 |


:

:

, .
==> ...

883 - | 790 -


© 2015-2024 lektsii.org - -

: 0.016 .