HP c-tree-SQL ISQL and Tools Manuel d'utilisateur télécharger pdf (Page 85)

Data Unload Utility: dbdump

FairCom Corporation 5-5

( no, name, loc ) FIELD DELIMITER ' ' ;

FOR RECORD dept_rec DUMP INTO deptrecs_out

USING SELECT dept_no , dept_name , location

FROM ADMIN.dept ;

The following is the commands file to write records from the customer table. The output data

file is cust_out which is a binary file in the fixed length record format.

DEFINE RECORD cust_rec OF FIXED LENGTH 37

AS (

no POSITION (1:4) LONG,

name POSITION (5:15) CHAR,

street POSITION (16:28) CHAR,

city POSITION (29:34) CHAR,

state POSITION (35:36) CHAR

) ;

FOR RECORD cust_rec DUMP INTO cust_out

USING SELECT cust_no, cust_name, cust_city, cust_street, cust_state

FROM ADMIN.customer ;

The following is the commands file to dump records from the orders table. The output data file

is orders_out which is a binary file in the fixed length record format.

DEFINE RECORD orders_rec OF FIXED LENGTH 31

AS (

no POSITION (1:4) LONG,

date POSITION (6:16) CHAR,

prod POSITION (18:25) CHAR,

units POSITION (27:30) LONG

) ;

FOR RECORD orders_rec DUMP INTO orders_out

USING SELECT order_no, order_date, product, quantity

FROM ADMIN.orders ;

1 2 ... 80 81 82 83 84 85 86 87 88 89 90 ... 98 99

Pas de commentaire

HP c-tree-SQL ISQL and Tools Manuel d'utilisateur Page 85