Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
CB                   Integer                   NO            
B                    Char      (   20)         YES             spanish         

SeLECT * FROM BIBLIOTECA;                                                 
-----------+--------------------                                           
CB         |B                                                              
-----------+--------------------                                           
          1|MATEMATICA

---------------------------------------------------------------------------
Number of rows selected is 1
COMMINT WORK;
HJ                                                                          
                 IIIIIIII    SSSSSSSS     QQQQQQQ      LL                     
                    II      SS           QQ     QQ     LL                     
                    II      SS           QQ     QQ     LL                     
                    II        SSSSSS     QQ     QQ     LL                     
                    II              SS   QQ   Q QQ     LL                     
                    II              SS   QQ     QQ     LL                     
                 IIIIIIII    SSSSSSS       QQQQQQ QQ   LLLLLLLLL              
                                                                              

                                         MON, APR 14, 1997,  3:55 PM 
HP36217-02A.E1.22           Interactive SQL/9000         ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992. ALL RIGHTS RESERVED.

 isql=> User's and DBE's languages are different. (DBWARN 10072)
 isql=> > > >  isql=> > CREATE TABLE REGISTRO( CB INT NOT NULL, I INT NOT NULL, R INT NOT NULL) 
 isql=> > >  isql=> > CREATE TABLE LIBRO( I INT NOT NULL, T CHAR(55)) IN datos2;
 isql=> > > >  isql=> CREATE TABLE SOCIO( DNI INT NOT NULL, A CHAR(10) NOT NULL, CB INT NOT 
 isql=> > > > > >  isql=> > CREATE TABLE PRESTAMO( DNI INT NOT NULL, CB INT NOT NULL, R INT NOT 
 isql=> > 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
I                    Integer                   NO            
T                    Char      (   55)         YES             spanish         

 isql=> 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
CB                   Integer                   NO            
I                    Integer                   NO            
R                    Integer                   NO            

 isql=> 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
DNI                  Integer                   NO            
A                    Char      (   10)         NO              spanish         
CB                   Integer                   NO            

 isql=> 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
DNI                  Integer                   NO            
CB                   Integer                   NO            
R                    Integer                   NO            
FP                   Date                      NO            
FD                   Date                      YES           

 isql=> > Number of rows processed is 1
 isql=> INSERT INTO BIBLIOTECA VALUES(1,'MATEMATICAS');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO BIBLIOTECA VALUES (2,'INFORMATICA');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO BIBLIOTECA VALUES(3,'ECONOMICAS');
 isql=> > 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
CB                   Integer                   NO            
B                    Char      (   20)         YES             spanish         

 isql=> > HJ
HSELECT * FROM BIBLIOTECA;                                                  K
-----------+--------------------                                           K
CB         |B                                                              K
-----------+--------------------                                           K
          1|MATEMATICASK
          2|INFORMATICAK
          3|ECONOMICASK













---------------------------------------------------------------------------
KNumber of rows selected is 3
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > Number of rows processed is 1
 isql=> INSERT INTO LIBRO VALUES (1001,'FUNDAMENTOS DE BASES DE DATOS');
 isql=> > HJ
HSELECT * FROM LIBRO;                                                       K
-----------+-------------------------------------------------------        K
I          |T                                                              K
-----------+-------------------------------------------------------        K
       1001|FUNDAMENTOS DE BASES DE DATOSK















---------------------------------------------------------------------------
KNumber of rows selected is 1
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO LIBRO VALUES (1011,'BASES DE DATOS RELACIONALES');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO LIBRO VALUES (1020,'USING MICROSOFT OFFICE');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO LIBRO VALUES (1025,'REGLAS Y CONSEJOS SOBRE INVESTIGACION 
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO LIBRO VALUES (2100,'APLIQUE SQL');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO LIBRO VALUES (2000,'TECNICAS DE BASES DE DATOS');
 isql=> > HJ
HSELECT * FROM LIBRO;                                                       K
-----------+-------------------------------------------------------        K
I          |T                                                              K
-----------+-------------------------------------------------------        K
       1001|FUNDAMENTOS DE BASES DE DATOSK
       1005|INTRODUCCION A LOS SISTEMAS DE BASES DE DATOSK
       1010|MICROSOFT WINDOWS 95K
       1011|BASES DE DATOS RELACIONALESK
       1020|USING MICROSOFT OFFICEK
       1025|REGLAS Y CONSEJOS SOBRE INVESTIGACION CIENTIFICAK
       2100|APLIQUE SQLK
       2000|TECNICAS DE BASES DE DATOSK








---------------------------------------------------------------------------
KNumber of rows selected is 8
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (3,2,1001);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (2,3,1010);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (1,1,1010);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (3,1,1020);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (3,3,2100);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (1,2,1005);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (1,3,1001);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (1,4,1011);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (2,2,1011);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (2,1,1020);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (3,4,1025);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (1,5,2100);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO REGISTRO VALUES (1,6,1020);
 isql=> > HJ
HSELECT * FROM REGISTRO;                                                    K
-----------+-----------+-----------                                        K
CB         |I          |R                                                  K
-----------+-----------+-----------                                        K
          3|          2|       1001K
          2|          3|       1010K
          1|          1|       1010K
          3|          1|       1020K
          3|          3|       2100K
          1|          2|       1005K
          1|          3|       1001K
          1|          4|       1011K
          2|          2|       1011K
          2|          1|       1020K
          3|          4|       1025K
          1|          5|       2100K
          1|          6|       1020K



---------------------------------------------------------------------------
KNumber of rows selected is 13
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (4444,'JUAN',1);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (3333,'MARIA',2);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (8888,'PEDRO',1);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (7777,'ANTONIO',3);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (6666,'CARMEN',2);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (1111,'ANGELA',1);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (8888,'PEDRO',3);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (2222,'JUAN',3);
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO SOCIO VALUES (6666,'CARMEN',1);
 isql=> > HJ
HSELECT * FROM SOCIO;                                                       K
-----------+----------+-----------                                         K
DNI        |A         |CB                                                  K
-----------+----------+-----------                                         K
       4444|JUAN      |          1K
       3333|MARIA     |          2K
       8888|PEDRO     |          1K
       7777|ANTONIO   |          3K
       6666|CARMEN    |          2K
       1111|ANGELA    |          1K
       8888|PEDRO     |          3K
       2222|JUAN      |          3K
       6666|CARMEN    |          1K







---------------------------------------------------------------------------
KNumber of rows selected is 9
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > Incompatible data types INTEGER and DATE in expression.  (DBERR 2609)
Number of rows processed is 0
 isql=> > 
INSERT INTO PRESTAMO VALUES(7777,3,1,1997-03-07,1997-03-11);
                                         |
Syntax error.  (DBERR 1001)
Number of rows processed is 0
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (7777,3,1,'1997-03-07','1997-03-11');
 isql=> > HJ
HSELECT * FROM PRESTAMO;                                                    K
-----------+-----------+-----------+----------+----------                  K
DNI        |CB         |R          |FP        |FD                          K
-----------+-----------+-----------+----------+----------                  K
       7777|          3|          1|1997-03-07|1997-03-11K















---------------------------------------------------------------------------
KNumber of rows selected is 1
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > Number of rows processed is 1
 isql=> > 
INSERT INTO PRESTAMO VALUES;
                           |
Syntax error.  (DBERR 1001)
Number of rows processed is 0
 isql=> > INSERT INTO PRESTAMO VALUES (1111,1,2,'1997-02-08');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (7777,3,3,'1997-01-15','1997-01-24');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (8888,1,2,'1996-03-09','1996-03-18');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (8888,3,2,'1997-01-01','1997-01-12');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (7777,3,1,'1995-04-01','1995-04-16');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (1111,1,3,'1997-02-18');
 isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (3333,2,2,'1997-01-01','1997-01-15');
 isql=> > > Terminate quoted string or enter / to abort the input.
>  isql=> > Number of rows processed is 1
 isql=> INSERT INTO PRESTAMO VALUES (6666,1,3,'1997-01-08','1997-02-17');
 isql=> > HJ
HSELECT * FROM PRESTAMO;                                                    K
-----------+-----------+-----------+----------+----------                  K
DNI        |CB         |R          |FP        |FD                          K
-----------+-----------+-----------+----------+----------                  K
       7777|          3|          1|1997-03-07|1997-03-11K
       1111|          1|          2|1997-02-08|K
       7777|          3|          3|1997-01-15|1997-01-24K
       8888|          1|          2|1996-03-09|1996-03-18K
       8888|          3|          2|1997-01-01|1997-01-12K
       7777|          3|          1|1995-04-01|1995-04-16K
       1111|          1|          3|1997-02-18|K
       3333|          2|          2|1997-01-01|1997-01-15K
       6666|          1|          3|1997-01-08|1997-02-17K







---------------------------------------------------------------------------
KNumber of rows selected is 9
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > 
SELECT (CB,B) FROM BIBLIOTECA;
          |
Syntax error.  (DBERR 1001)
 isql=> 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
CB                   Integer                   NO            
B                    Char      (   20)         YES             spanish         

 isql=> > 
SELECT (CB,B) FROM BIBLIOTECA;
          |
Syntax error.  (DBERR 1001)
 isql=> > HJ
HSELECT CB,B FROM BIBLIOTECA;                                               K
-----------+--------------------                                           K
CB         |B                                                              K
-----------+--------------------                                           K
          1|MATEMATICASK
          2|INFORMATICAK
          3|ECONOMICASK













---------------------------------------------------------------------------
KNumber of rows selected is 3
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > HJ
HSELECT * FROM LIBRO;                                                       K
-----------+-------------------------------------------------------        K
I          |T                                                              K
-----------+-------------------------------------------------------        K
       1001|FUNDAMENTOS DE BASES DE DATOSK
       1005|INTRODUCCION A LOS SISTEMAS DE BASES DE DATOSK
       1010|MICROSOFT WINDOWS 95K
       1011|BASES DE DATOS RELACIONALESK
       1020|USING MICROSOFT OFFICEK
       1025|REGLAS Y CONSEJOS SOBRE INVESTIGACION CIENTIFICAK
       2100|APLIQUE SQLK
       2000|TECNICAS DE BASES DE DATOSK








---------------------------------------------------------------------------
KNumber of rows selected is 8
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > HJ
HSELECT I FROM REGISTRO;                                                    K
-----------                                                                K
I                                                                          K
-----------                                                                K
          2K
          3K
          1K
          1K
          3K
          2K
          3K
          4K
          2K
          1K
          4K
          5K
          6K



---------------------------------------------------------------------------
KNumber of rows selected is 13
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > HJ
HSELECT I FROM REGISTRO;                                                    K
-----------                                                                K
I                                                                          K
-----------                                                                K
          2K
          3K
          1K
          1K
          3K
          2K
          3K
          4K
          2K
          1K
          4K
          5K
          6K



---------------------------------------------------------------------------
KNumber of rows selected is 13
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> 
Column Name          Data Type (length)     Nulls Allowed      Language
----------------------------------------------------------------------------
CB                   Integer                   NO            
I                    Integer                   NO            
R                    Integer                   NO            

 isql=> Number of rows processed is 13
 isql=> > HJ
HSELECT * FROM REGISTRO;                                                    K
-----------+-----------+-----------                                        K
CB         |I          |R                                                  K
-----------+-----------+-----------                                        K
















---------------------------------------------------------------------------
KNumber of rows selected is 0
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=>  isql=> > > >  isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> > Number of rows processed is 1
 isql=> HJ
HSELECT I FROM REGISTRO;                                                    K
-----------                                                                K
I                                                                          K
-----------                                                                K
       1001K
       1010K
       1010K
       1020K
       2100K
       1005K
       1001K
       1011K
       1011K
       1020K
       1025K
       2100K
       1020K



---------------------------------------------------------------------------
KNumber of rows selected is 13
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > HJ
HSELECT * FROM REGISTRO;                                                    K
-----------+-----------+-----------                                        K
CB         |R          |I                                                  K
-----------+-----------+-----------                                        K
          3|          2|       1001K
          2|          3|       1010K
          1|          1|       1010K
          3|          1|       1020K
          3|          3|       2100K
          1|          2|       1005K
          1|          3|       1001K
          1|          4|       1011K
          2|          2|       1011K
          2|          1|       1020K
          3|          4|       1025K
          1|          5|       2100K
          1|          6|       1020K



---------------------------------------------------------------------------
KNumber of rows selected is 13
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > HJ
HSELECT R,I,CB FROM REGISTRO;                                               K
-----------+-----------+-----------                                        K
R          |I          |CB                                                 K
-----------+-----------+-----------                                        K
          2|       1001|          3K
          3|       1010|          2K
          1|       1010|          1K
          1|       1020|          3K
          3|       2100|          3K
          2|       1005|          1K
          3|       1001|          1K
          4|       1011|          1K
          2|       1011|          2K
          1|       1020|          2K
          4|       1025|          3K
          5|       2100|          1K
          6|       1020|          1K



---------------------------------------------------------------------------
KNumber of rows selected is 13
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=>  A transaction is in progress.  Commit work (Y/N)> HJ                                                                          
                 IIIIIIII    SSSSSSSS     QQQQQQQ      LL                     
                    II      SS           QQ     QQ     LL                     
                    II      SS           QQ     QQ     LL                     
                    II        SSSSSS     QQ     QQ     LL                     
                    II              SS   QQ   Q QQ     LL                     
                    II              SS   QQ     QQ     LL                     
                 IIIIIIII    SSSSSSS       QQQQQQ QQ   LLLLLLLLL              
                                                                              

                                         TUE, APR 15, 1997,  4:09 PM 
HP36217-02A.E1.22           Interactive SQL/9000         ALLBASE/SQL
(C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
1989,1990,1991,1992. ALL RIGHTS RESERVED.

 isql=> > User's and DBE's languages are different. (DBWARN 10072)
 isql=> > HJ
HSELECT A,DNI,CB FROM SOCIO;                                                K
----------+-----------+-----------                                         K
A         |DNI        |CB                                                  K
----------+-----------+-----------                                         K
JUAN      |       4444|          1K
MARIA     |       3333|          2K
PEDRO     |       8888|          1K
ANTONIO   |       7777|          3K
CARMEN    |       6666|          2K
ANGELA    |       1111|          1K
PEDRO     |       8888|          3K
JUAN      |       2222|          3K
CARMEN    |       6666|          1K







---------------------------------------------------------------------------
KNumber of rows selected is 9
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > HJ
HSELECT * FROM PRESTAMO;                                                    K
-----------+-----------+-----------+----------+----------                  K
DNI        |CB         |R          |FP        |FD                          K
-----------+-----------+-----------+----------+----------                  K
       7777|          3|          1|1997-03-07|1997-03-11K
       1111|          1|          2|1997-02-08|K
       7777|          3|          3|1997-01-15|1997-01-24K
       8888|          1|          2|1996-03-09|1996-03-18K
       8888|          3|          2|1997-01-01|1997-01-12K
       7777|          3|          1|1995-04-01|1995-04-16K
       1111|          1|          3|1997-02-18|K
       3333|          2|          2|1997-01-01|1997-01-15K
       6666|          1|          3|1997-01-08|1997-02-17K







---------------------------------------------------------------------------
KNumber of rows selected is 9
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DNI FROM PRESTAMO WHERE CB=3;                                       K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       7777K
       7777K
       8888K
       7777K












---------------------------------------------------------------------------
KNumber of rows selected is 4
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DISTINCT DNI FROM PRESTAMO WHERE CB=3;                              K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       7777K
       8888K














---------------------------------------------------------------------------
KNumber of rows selected is 2
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT T FROM LIBRO WHERE I >= 1015;                                       K
-------------------------------------------------------                    K
T                                                                          K
-------------------------------------------------------                    K
USING MICROSOFT OFFICEK
REGLAS Y CONSEJOS SOBRE INVESTIGACION CIENTIFICAK
APLIQUE SQLK
TECNICAS DE BASES DE DATOSK












---------------------------------------------------------------------------
KNumber of rows selected is 4
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT T FROM LIBRO WHERE I >1015;                                         K
-------------------------------------------------------                    K
T                                                                          K
-------------------------------------------------------                    K
USING MICROSOFT OFFICEK
REGLAS Y CONSEJOS SOBRE INVESTIGACION CIENTIFICAK
APLIQUE SQLK
TECNICAS DE BASES DE DATOSK












---------------------------------------------------------------------------
KNumber of rows selected is 4
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT I FROM LIBRO WHERE T='FUNDAMENTOS DE BASES DE DATOS';               K
-----------                                                                K
I                                                                          K
-----------                                                                K
       1001K















---------------------------------------------------------------------------
KNumber of rows selected is 1
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT T FROM LIBRO WHERE I <> 1015;                                       K
-------------------------------------------------------                    K
T                                                                          K
-------------------------------------------------------                    K
FUNDAMENTOS DE BASES DE DATOSK
INTRODUCCION A LOS SISTEMAS DE BASES DE DATOSK
MICROSOFT WINDOWS 95K
BASES DE DATOS RELACIONALESK
USING MICROSOFT OFFICEK
REGLAS Y CONSEJOS SOBRE INVESTIGACION CIENTIFICAK
APLIQUE SQLK
TECNICAS DE BASES DE DATOSK








---------------------------------------------------------------------------
KNumber of rows selected is 8
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT T FROM LIBRO WHERE (I <>1015) AND (I <> 2000);                      K
-------------------------------------------------------                    K
T                                                                          K
-------------------------------------------------------                    K
FUNDAMENTOS DE BASES DE DATOSK
INTRODUCCION A LOS SISTEMAS DE BASES DE DATOSK
MICROSOFT WINDOWS 95K
BASES DE DATOS RELACIONALESK
USING MICROSOFT OFFICEK
REGLAS Y CONSEJOS SOBRE INVESTIGACION CIENTIFICAK
APLIQUE SQLK









---------------------------------------------------------------------------
KNumber of rows selected is 7
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT CB FROM SOCIO WHERE A='CARMEN';                                     K
-----------                                                                K
CB                                                                         K
-----------                                                                K
          2K
          1K














---------------------------------------------------------------------------
KNumber of rows selected is 2
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT CB FROM BIBLIOTECA WHERE B='MATEMATICAS';                           K
-----------                                                                K
CB                                                                         K
-----------                                                                K
          1K















---------------------------------------------------------------------------
KNumber of rows selected is 1
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DNI FROM PRESTAMO WHERE FP ='1997-01-01';                           K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       8888K
       3333K














---------------------------------------------------------------------------
KNumber of rows selected is 2
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DNI FROM SOCIO WHERE A IN ('JUAN','ANTONIO','CARMEN');              K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       4444K
       7777K
       6666K
       2222K
       6666K











---------------------------------------------------------------------------
KNumber of rows selected is 5
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DNI FROM SOCIO WHERE A NOT IN ('JUAN','ANTONIO','CARMEN');          K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       3333K
       8888K
       1111K
       8888K












---------------------------------------------------------------------------
KNumber of rows selected is 4
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DNI FROM SOCIO WHERE DNI BETWEEN 2800 AND 5000;                     K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       4444K
       3333K














---------------------------------------------------------------------------
KNumber of rows selected is 2
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DNI FROM SOCIO WHERE DNI NOT BETWEEN 2800 AND 5000;                 K
-----------                                                                K
DNI                                                                        K
-----------                                                                K
       8888K
       7777K
       6666K
       1111K
       8888K
       2222K
       6666K









---------------------------------------------------------------------------
KNumber of rows selected is 7
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=> > > HJ
HSELECT DISTINCT R FROM REGISTRO WHERE CB=1;                                K
-----------                                                                K
R                                                                          K
-----------                                                                K
          1K
          2K
          3K
          4K
          5K
          6K










---------------------------------------------------------------------------
KNumber of rows selected is 6
K U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > J

 isql=>  A transaction is in progress.  Commit work (Y/N)> 