Exemple : Déchargement des données au format de sortie JSON

Rapport d'exécution :

[i1053@vmdb2:~> db2hpu --debug -i i1053 -f sysin_json
INZM031I Optim High Performance Unload for Db2 06.01.00.001(150526) 
         64 bits 05/26/2015 (Linux vmdb2 3.11.10-21-desktop #1 86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----
000001 GLOBAL CONNECT TO SAMPLE
000002 ;
000003 
000004 UNLOAD TABLESPACE DB2 NO
000005 
000006 SELECT EMPNO, FIRSTNME, LASTNAME, HIREDATE, EDLEVEL, SALARY FROM EMPLOYEE;
000007 OUTFILE("outfile")
000009 FORMAT JSON
000010 ;

INZU462I HPU control step start: 05/26/2015 15:53:29.838.
INZU463I HPU control step end  : 05/26/2015 15:53:30.250.
INZU464I HPU run step start    : 05/26/2015 15:53:30.298.
INZU410I HPU utility has unloaded 42 rows on vmdb2 host for I1053.EMPLOYEE in outfile.
INZU465I HPU run step end      : 05/26/2015 15:53:34.073.
INZI441I HPU successfully ended: Real time -> 0m4.235023s
User time -> 0m0.021000s : Parent -> 0m0.019000s, Children -> 0m0.002000s
Syst time -> 0m0.035000s : Parent -> 0m0.031000s, Children -> 0m0.004000s

Extrayez le fichier de sortie généré :

{"EMPNO":"000010","FIRSTNME":"CHRISTINE","LASTNAME":"HAAS","HIREDATE":"1995-01-01","EDLEVEL":18,"SALARY":152750.00},
...
{"EMPNO":"200340","FIRSTNME":"ROY","LASTNAME":"ALONZO","HIREDATE":"1997-07-05","EDLEVEL":16,"SALARY":31840.00}

Après avoir exécuté Optim™ High Performance Unload contre ce fichier de contrôle, on peut constater que le fichier de sortie généré contient les lignes du tableau formatées au format JSON, mais ne contient pas d'en-tête ni de pied de page.