Diapositive PPT

val=0; /* compteur du nombre de tuples */

while (1)

{

EXEC SQL WHENEVER NOT FOUND DO

break;

EXEC SQL FETCH csa INTO

:dir, :from, :to;

i=dir.len;

while(dir.arr[i-1]==' ') i--;

dir.arr[i]='\0';

printf("%s # ", dir.arr);

i=from.len;

while(from.arr[i-1]==' ') i--;

from.arr[i]='\0';

printf("%s # ", from.arr);

i=to.len;

while(to.arr[i-1]==' ') i--;

to.arr[i]='\0';

printf("%s \n ", to.arr);

val++;

}

EXEC SQL CLOSE csa;

printf("%d\n",val);

deconnection();

EXEC SQL INCLUDE SQLCA;

EXEC SQL BEGIN DECLARE SECTION;

char *dbaccess="bda10/bda@T:zazie:o1";

VARCHAR dir[50];

VARCHAR from[40];

VARCHAR to[40];

EXEC SQL END DECLARE SECTION;

char Buf[1024];

connection();

EXEC SQL DECLARE csa CURSOR FOR

SELECT d.direction, s1.nom_station, s2.nom_station

FROM metro.quais q, metro.stations s1,

metro.stations s2, metro.directions d

WHERE q.ns = s1.ns and q.nss = s2.ns and

q.nd = d.nd

ORDER BY d.direction, q.ns;

EXEC SQL OPEN csa;

Embedded SQL

Diapositive précédente

Diapositive suivante

Revenir à la première diapositive

Afficher la version graphique