Bloc UNLOAD

Le bloc UNLOAD est obligatoire pour chaque déchargement. Il fournit de nombreuses commandes de base pour un déchargement. Ce bloc peut apparaître plus d'une fois dans un fichier de contrôle.

Le diagramme de syntaxe ci-après illustre le bloc UNLOAD.

Attention: ce bloc doit se terminer par un point-virgule.
Figure 1 : Bloc UNLOAD

1 
2.1 UNLOAD
2.1 MIGRATE
2.1  DATABASE?  db_name
2.1  TABLESPACE?  ts_name
1  PART  (
2.1 ALL
2.2.1+ ,
2.2.1 nn
2.2.1 nn:nn
1 )
1  ONLY TABLES
2.1  (
2.2.1+ ,
2.2.1 tablename
2.2.1 qualifier.tablename
2.1 )
2.1  IN "filename"
1  EXCEPT TABLES
2.1  (
2.2.1+ ,
2.2.1 tablename
2.2.1 qualifier.tablename
2.1 )
2.1  IN "filename"
1  HEADER
2.1 FIRST
2.1 NONE
2.1 ALL
2.1  EXTERNAL "filename"
6?  HIDDEN
7.1 NO
7.1 YES
1  LOADFILE (
2.1 "path/filename"
2.1 "host:path/filename"
1 )
1  LOADMODE
2.1 load_mode
2.1  ( load_mode?  WITH dpf_load_mode )
Suite du bloc UNLOAD :

1  LOADOPT
2.1  (
2.2.1+ ,
2.2.1  SAVECOUNT nn
2.2.1  ROWCOUNT nn
2.2.1  WARNINGCOUNT nn
2.2.1  MESSAGES "filename"
2.2.1  TEMPFILES PATH "pathname"
2.2.1  STATISTICS
2.2.2.1 USE PROFILE
2.2.2.1 NO
2.2.1 load_recovery_option
2.2.1  DATA BUFFER nn
2.2.1  SORT BUFFER nn
2.2.1  CPU_PARALLELISM nn
2.2.1  DISK_PARALLELISM nn
2.2.1  INDEXING MODE
2.2.2.1 AUTOSELECT
2.2.2.1 REBUILD
2.2.2.1 INCREMENTAL
2.2.2.1 DEFERRED
2.2.1  ALLOW
2.2.2.1 NO ACCESS
2.2.2.1  READ ACCESS
2.2.2.2.1  USE tsname
2.2.1  SET INTEGRITY PENDING CASCADE
2.2.2.1 IMMEDIATE
2.2.2.1 DEFERRED
2.2.1 LOCK WITH FORCE
2.1 )
2?  LOADTEMPFILES ( "path" )
1  INTERVAL nn
1  DB2
2.1 YES
2.1 NO
1  format_clause
1 +  SELECT select_clause
1  outfile_clause
1  LOCK
2.1 YES
2.1 NO
1  FLUSH BUFFERPOOLS
2.1 YES
2.1 NO
1  SIZELIMIT
2.1 integerK
2.1 integerM
2.1 integerG
Suite du bloc UNLOAD :

1?  SCHEMA schema_name?  SHARED_DATAPART_PROCESSING
2.1 NO
2.1 YES?  TARGET KEYS  (
2.1 DEFAULT
2.1 CURRENT
2.1  PARTS
2.2.1  (
2.2.2.1! ALL
2.2.2.1 
2.2.2.2.1+ ,
2.2.2.2.1 nn
2.2.2.2.1 nn:nn
2.2.1 )
2.2.1?  IN ”filename” )
1  SKIP nn
1  LOB IN ( + , "lob_path_with_template"
2.1 for_parts_clause )
1  LOBFILE ( + , "base_file_name_with_template" )
1  XML IN ( + , "xml_path_with template"
2.1 for_parts_clause )
1  XMLFILE ( + , "base_file_name-with-template" )
1  FILEMAXSIZE
2.1 integerK
2.1 integerM
2.1 integerG
1  options_clause
1  CCSID ( ccsid_mixed
2.1  , ccsid_dbcs
1 )
1  ASIS
1  ASCII
1  UNICODE
1  EBCDIC
1  LOCALE
1 
2.1 database_backup block
2.1 copy block
10?  MAXTHREADS n
1  TARGET ENVIRONMENT ( target_db2nodes_specification?  IN dbname?  TENANT tenant_name?  REPART
2.1 NO
2.1 PMAP_4K
2.1 PMAP_32K )
11?  WORKING IN ( "dirname"? WITH FILES? 
12.1 UNIX
12.1 WINDOWS
11 PATH )
11?  replace_string_clause
11?  translate_string_clause
Suite du bloc UNLOAD :

1  DDLFILE (
2.1 "path/filename"
2.1 "host:path/filename"
1 )
1  DDLOPT (
2.1+ ,
2.1 WITH LIKE CLAUSE
2.1  IN ( + , 'tablespace_name' )
1 )
3?  LOBINLINESIZE nnK
1  INTO TABLES
2.1  ( + , tables_pair_spec?  columns_pair_spec ?  IN (
2.2.1+ ,
2.2.1 tsname
2.1 ) )
2.1  IN "path/filename"
2.1  WITH SCHEMA schema_name
1  TABLES MODIFIERS
2.1  ( + ,  ( + , modifier )? 
2.2.1 FOR
2.2.1 EXCEPT
2.1  ( + ,
2.2.1 tablename
2.2.1 qualifier.tablename ) )
2.1  IN "filename"
5?  XMLSERIALIZE ( xmlserialization_spec )
1  OVERRIDE ( + , "original_dir" BY "new_dir" )
1  SEARCH (  "search_dir" )
1  MAXROWS nn
7?  STAGING IN ( "dirname" )
1  loaddest_clause
8  ;
Suite de la clause TARGET ENVIRONMENT :
Figure 2. target_db2nodes_specification:

1  INSTANCE "instance_name"
2.1?  ON "hostname"
2.1  FILE "filename_with_template"?  EXCEPT PARTS (
2.1+ ,
2.1 nn
2.1 nn:nn
1 )
Suite de la clause LOADMODE :
Figure 3. load_mode :

1 INSERT
1  REPLACE
2.1 KEEPDICTIONARY
2.1 RESETDICTIONARY
1 RESTART
1 TERMINATE
Suite de la clause LOADMODE pour les environnements PDF :
Figure 4. dpf_load_mode :

1 LOAD_ONLY
1 LOAD_ONLY_VERIFY_PART
1 PARTITION_ONLY
1 PARTITION_AND_LOAD
Suite de la clause LOADOPT :
Figure 5. load_recovery_option :

1 NONRECOVERABLE
1  COPY
2.1 NO
2.1  YES (
2.2.1  USE TSM
2.2.2.1  OPEN nn SESSIONS
2.2.1  TO + , "directory"
2.2.1  LOAD "shared library"
2.2.2.1?  OPEN nn SESSIONS
2.1 )
Suite de la clause INTO TABLES :
Figure 6. tables_pair_spec :

1 
2.1 src_tbname
2.1 src_qualifier.src_tbname  : 
2.1 tgt_tbname
2.1 tgt_qualifier.tgt_tbname
Figure 7. columns_pair_spec :

1  WITH COLUMNS (
2.1 + ' src_col:tgt_col
2.1  dft_colfamily?  , + , src_col:tgt_col:colfamily
1 )
Suite de la clause XMLSERIALIZE :
Figure 8. xmlserialization_spec :

2.1 
2.2.1 CHARACTER
2.2.1 CHAR
2.1?  ( integer
2.2.1 OCTETS
2.2.1 CODEUNITS32
2.1 )
2.1 
2.2.1 VARCHAR
2.2.1 
2.2.2.1 CHARACTER
2.2.2.1 CHAR
2.2.1 VARYING
2.1  ( integer
2.2.1 OCTETS
2.2.1 CODEUNITS32
2.1 )
2.1 
2.2.1 CLOB
2.2.1 
2.2.2.1 CHARACTER
2.2.2.1 CHAR
2.2.1 LARGE OBJECT
2.1?  ( integer
2.2.1 K
2.2.1 M
2.2.1 G
2.2.1 OCTETS
2.2.1 CODEUNITS32
2.1 )
2.1 
2.2.1 BLOB
2.2.1  BINARY LARGE OBJECT
2.1?  ( integer
2.2.1 K
2.2.1 M
2.2.1 G
2.1 )
1 
2.1 EXCLUDING
2.1 INCLUDING
1 XMLDECLARATION