Example 6 19   Sample data of MySQL data

mysql> select * from catalog limit 1;

+            +              +      +         +         +      +      +      +      +                 

+      +       +           +      +          +            +         +    +

|manufacturer| model        | type |year_from| year_to | kw   | hp

__

 | ccm  | cyl  | motorcode       

| pg   | sku 

__

| dimension | ac   | transmiss| hint

______

 | stock

__

 | id |

+            +              +      +         +         +      +      +      +      +                 

+      +       +           +      +          +            +         +    +

| VW         | PASSAT (3B2) | 1.6  | 10.1996 | 11.2000 | 74   | 101  | 1595 | 4    | ADP/AHL/ANA/ARM 

| 10   | 16633 | 630 420   | +/   | M        | see figure |      10 |  2 |

+            +              +      +         +         +      +      +      +      +                 

+      +       +           +      +          +            +         +    +

1 row in set (0.05 sec)

db2 => select * from itsodb.catalog where manufacturer= VW  and model= PASSAT (3B2)  and type= 1.6 

MANUFACTURER

__

 MODEL                     TYPE

_____________________

 YEAR_FR YEAR_TO KW

_

 HP

_

 CCM

_

 CYL 

MOTORCODE                                                    PR SKU

_____

 DIMENSION

____

AC

_

 TRANSMIS 

HINT

________________________________________________________

 STOCK

______

 ID

VW             PASSAT (3B2)              1.6                       10.1996 11.2000 74  101 1595 4   

ADP/AHL/ANA/ARM                                              10 16633    630 420      +/  M        

see figure                                                            10           2

  1 record(s) selected.

 Chapter 6. Data porting 

153